SAS VA - Drill down in barchart on SAS Viya

[Derick]

I want to create my barchart which able to drill down to week of Year from the Year > Month > week of Year.  I have Reference date column in DDMMMMYYYY format and have Amount column.  I drag the bar chart to the designer, at the right pane, I choose role and assign Reference date in Categories and asign Amount i Measure.

How I can set my Reference date in categories just show year, then click to drill down to Month then to week of the year?

I try to duplicate Reference date column and change the duplicate column format to Year.  But I got no idea how make it drill down.

Please guide me.  Thanks

[Madelyn_SAS]

Create a hierarchy of the data items, which will enable you to drill. 

I am not sure Week is a supported format. Which version do you have? 

[Derick]

May I know how to do a hierarchy data items?  I think I'm using the Viya version 03.04

[Madelyn_SAS]

In the Data pane on the left, click New data item > Hierarchy. 

Add your three data items (year, month, week in the correct order). 

Add your hierarchy to the bar chart. Here it is drilled to week. 

[Derick]

Thanks for the guide, it's work now.