cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

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
Rate this article:
Version history
Last update:
‎03-02-2023 08:30 AM
Updated by:
Contributors