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)
... View more