SAS VA Drill Down from Category to Numeric

[ChristyN]

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!

[TSBruce]

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#p0w4...

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