I am trying to develop a graph (in SAS VA 7.1) that has both Month and Week metrics. We want to be able to see the graph at a monthly view, but then if we click a drop down or button we can change that same view to week. It would change the category from month to week.
The only way so far that I can figure out how to do this is to use the time metric as a text field and then concatenate the dataset together by stacking month on top of week. It has a variable called time (month or week). As you pick it it changes the graph.
The issue (as i am sure you're all aware), is that since it's a text varibable it sorts in alphabetical order.
I can't really use the custom sort since the data changes and there are way more weeks than the custom sort will allow.
Any ideas? I have been all over this community but have not seen any thing.
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.