topic Re: SAS VA - Date Hierarchy, wrong order in SAS Visual Analytics

SAS VA - Date Hierarchy, wrong order

MariaD — Wed, 26 Sep 2018 15:31:00 GMT

Hi Folks,

I created a date hierarchy (Year --> Quarter --> Month --> Day of week). I'm duplicate the original date variable and I changed the visualization format. I'm using the name of month but I tested with month number and the problem is the same.

After that, I added a graph but the order inside each hierarchy is wrong. For example, shows first the second quarter and then first quarter.

Any idea?

Re: SAS VA - Date Hierarchy, wrong order

Madelyn_SAS — Wed, 26 Sep 2018 16:12:00 GMT

Display the graph at the top level of the hierarchy (Year). At the bottom of the graph, click on the Year label. You should see a menu that includes Sort. Sort in Ascending order.

Re: SAS VA - Date Hierarchy, wrong order

MariaD — Wed, 26 Sep 2018 22:04:35 GMT

Thanks! @Madelyn_SAS