BookmarkSubscribeRSS Feed
Obsidian | Level 7



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.





graph sort issue.png
SAS Employee
Would it help to define Month-Week as a time hierarchy?
Obsidian | Level 7

Thamks for the reply.


I actually tried that.  It would only work if there was a control that "expanded" all time metrics.  It won't let me add hierarchy to any type of control.





The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.


Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 


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
  • 2 replies
  • 2 in conversation