Knowledge Base Article

Filter dashboard on latest year based on the Elasticube data

mceclip1.png 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 

mceclip2.png 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.

mceclip3.png 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
mceclip0.png
filtering on "This Year' will filter out all the data from the dashboard 
mceclip1.png
Adding the anchor to the advanced filter 
mceclip2.png
Dashboard shows data from year 2013 (the latest year in the dataset)
mceclip3.png
Updated 03-02-2023
No CommentsBe the first to comment