BookmarkSubscribeRSS Feed
Robespierre
Calcite | Level 5

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)

1 REPLY 1
SASKiwi
PROC Star

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. 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 760 views
  • 0 likes
  • 2 in conversation