Filter dashboard on latest year based on the Elasticube data
Analytical Need
Fact tables may include a wide date range. For instance, a table can have historical dates without any transaction of the current year,
The Need : filter the dashboard based on the latest year in the data
Modeling Challenge
We need to filter the dashboard based on the latest year in the data,
Using the Time Frame option in the filter will use the server time.
Solution
Using the Anchor in the advanced filter will filter the dashboard based on the latest year in the data.
Historical data of 2011,2012 & 2013

filtering on "This Year' will filter out all the data from the dashboard

Adding the anchor to the advanced filter

Dashboard shows data from year 2013 (the latest year in the dataset)

Updated 03-02-2023
intapiuser
Admin
Joined December 15, 2022