# Use max(date) for last date in metric sheet

**URL:** <https://community.holistics.io/t/use-max-date-for-last-date-in-metric-sheet/2114>\
**Category:** Feature Suggestions\
**Tags:** visualizations, metric-sheet, dashboard\
**Created:** [September 26, 2024, 3:49pm UTC](https://community.holistics.io/t/use-max-date-for-last-date-in-metric-sheet/2114 "2024-09-26T15:49:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stonematt](https://community.holistics.io/letter_avatar_proxy/v4/letter/s/bc79bd/32.png) [@stonematt](https://community.holistics.io/u/stonematt)\
**Post date:** [September 26, 2024, 3:49pm UTC](https://community.holistics.io/t/use-max-date-for-last-date-in-metric-sheet/2114/1 "2024-09-26T15:49:31Z")

</div>

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:

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

```

and

```auto
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.

 ![CleanShot 2024-09-26 at 08.35.58@2x](https://community.holistics.io/uploads/default/original/2X/2/291f6b1440fc1e82dcd0acc215322f1a2cc8d9a4.png)

---

<div class="post-metadata">

**Author:** ![stonematt](https://community.holistics.io/letter_avatar_proxy/v4/letter/s/bc79bd/32.png) [@stonematt](https://community.holistics.io/u/stonematt)\
**Post date:** [September 26, 2024, 3:53pm UTC](https://community.holistics.io/t/use-max-date-for-last-date-in-metric-sheet/2114/2 "2024-09-26T15:53:38Z")

</div>

Trying to get this to always have data:

 ![CleanShot 2024-09-26 at 08.53.03@2x](https://community.holistics.io/uploads/default/original/2X/2/2cc56a823d4d8c54545c8c6d3a06dfef985b6e82.png)

---

<div class="post-metadata">

**Author:** ![Phuong\_N\_Holistics](https://community.holistics.io/user_avatar/community.holistics.io/phuong_n_holistics/32/1420_2.png) [@Phuong\_N\_Holistics](https://community.holistics.io/u/Phuong_N_Holistics)\
**Post date:** [September 27, 2024, 7:37am UTC](https://community.holistics.io/t/use-max-date-for-last-date-in-metric-sheet/2114/3 "2024-09-27T07:37:01Z")

</div>

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.