SAS VA Drill Down from Category to Numeric

ChristyN — Thu, 01 Feb 2024 22:00:37 GMT

SAS VA 8.5.2 - I would like to create a hierarchy(?) where the user can click on a categorical value in a bar chart (<24 hrs, 24-48 hrs, ..) and have it drill down to the numeric values behind the category (e.g. click on '<24 hrs' and it opens another bar chart showing the distribution of hours for this group). Trying to create a hierarchy does not let me use the numeric hours variable. Any ideas?

Thanks in advance!

Re: SAS VA Drill Down from Category to Numeric

TSBruce — Thu, 01 Feb 2024 22:06:34 GMT

Hi Christy-

You might try duplicating your numeric data item (Hours) and then changing the duplicated data item from a measure to a category. That should allow you to use this within a hierarchy.

Duplicate data item - https://go.documentation.sas.com/doc/en/vacdc/8.5/vareportdata/p1tm26sodb94w9n1hz81bz75plk7.htm#p0w4ro9jkj2ymjn17nu5qiz021hb

Modify data item classification - https://go.documentation.sas.com/doc/en/vacdc/8.5/vareportdata/p1tm26sodb94w9n1hz81bz75plk7.htm#p0xve42cyshrugn18yywpbexfyyv

topic Re: SAS VA Drill Down from Category to Numeric in SAS Visual Analytics

SAS VA Drill Down from Category to Numeric

Re: SAS VA Drill Down from Category to Numeric