Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart that is showing data for the last 2 months which is Nov and Oct 2022.
When I click on the filter to filter our data by week, the drop down list only provide the option to select weekly data from year 2019 and 2020.
What should I do to show the weekly data for 2022 which is the current year instead of showing weekly data for the past years?
you can add a calculated dimension for the Week filter as below, but this will be slower
replace
=WEEK
with
=aggr(only({<YEAR={"=Max(YEAR)"}>}WEEK),WEEK)