Use max(date) for last date in metric sheet

[stonematt (Matt)]

I’m using a metrics sheet to show data over the course of a 7d event using a date dimension called “completed”. After the 7th day, there is no more data collected, so day over day the metric sheet show “no activity” each day.

How do I show the last N columns since the “max completed date”. I tried to make an ad hoc filter on the report like:

where(stack_assignment_timing.completed < max(stack_assignment_timing.completed))

and

stack_assignment_timing
| where(stack_assignment_timing.completed < max(stack_assignment_timing.completed))

Neither worked to pin the last day of the metric sheet to the most recent date of data in the dataset.

This simple filter, where I pick an explicit date, works as designed for “this event”, but the explicit date isn’t appropriate for previous events.

[stonematt (Matt)]

Trying to get this to always have data:

[Phuong_N_Holistics (Phuong Nguyen)]

Hi @stonematt

Thank you for your feedback. Our metric sheet is designed to always show data up to yesterday. We understand that you want to display the metric sheet up to the date where the data is last available. It’s indeed a valid use case. So we’ve changed your thread to Feature Suggestion, so that other users can upvote it as well.

We’ve put this request in our backlog and will let you know when we have a concrete solution to improve it.

Thank you so much,
Phuong.