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)
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.