Filtering KPI value with three separate time filters

[Robespierre]

Okay, this might be just simple, but I just don’t get it.

The business use case is to have week/month/year based time selection and see difference value from previous year. So if I choose 01/01/2018 I should see difference from 01/01/2017. Simple enough.

The first problem is that I can’t create one single time category with Week/Month/Year. Is this even possible in SAS VA 7.4?

To get around this, I created three separate time filters. One for each (week, month and year) which each filtering each other. The problem after this solution is that I find it quite difficult to understand how the calculation logic is created for KPI meter.

Can you help me out? I think there is some better solutions than I have figured out.

(I have following columns for date: DD/MM/YYYY, year, month, day and week number created by SAS function)

[SASKiwi]

How about thinking about your problem differently? I find date sliders useful for date-related filtering. With the start and stop date on the slider you can choose any year, month, week or any time period.

If your data covers a long period you could use a year drop-down filter in combination with a slider. That way it only covers one year.