You can create a calculated field like this:
Put it on the filters shelf and set it as true.
Then bring in your ids into rows and set the measure as an average:
Please see attached workbook.
Less than 90days.twbx 485.0 KB
1 of 1 people found this helpful
Can you try using the date filter.
Drag the [Date] field in the filter with type Month/ Day / Year.
Select "Use all" in the General Tab.
In the Top Use Top 90 by the [Date] field and Aggregation as Maximum.
This will always keep the filter by Top 90 days of data available even when you refresh the data.
Thank you Mavis. That worked.
Hi Sohan I have tried your solution as well and it works just the same.
Thank you very much.