Using set analysis filter and date picker simultaneously

[PK1]

Hi All,

I have a requirement where i need to create a dashboard in which by default it should show the data as per the latest week, but if someone select the date range from date picker then the data should get updated as per the range selected.

Kindly help

[JordyWegman]

Hi PK,

What you can do, is cap the calendar on the max current month. Meaning that, your calendar won't contain any data later than this current day/week.

Then use the Max week in your set analysis. Sum({$< Week = {"$(=Max(Week))"}>}Sales). When you make a selection, it will still give the data you need.

If you have some test data that would be helpfull and an example what the outcome should be.

Jordy

Climber