Analytical Need
As a dashboard designer I want to present yesterday’s data since the data is built every night.
But in cases where yesterday is not a working day (Saturday / Holiday / etc.), then I would like to present the latest data.
Solution
In order to filter on the latest day that has data you can use the dashboard date filter, please follow the next steps:
- Add a date dashboard / Widget filter (Make sure it’s in a day granularity)
- Edit the date filter, Click on the 'Advanced' option and paste the following:
{ "last": { "count": 1, "offset": 0, "anchor": "last" }, "custom": true }
3. Test the filter - It should present the latest date available.
*Note: This functionality is currently applicable in Windows deployments only.