topic SAS VA - Drill down in barchart on SAS Viya in SAS Visual Analytics

SAS VA - Drill down in barchart on SAS Viya

Derick — Wed, 17 Jul 2019 09:21:18 GMT

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

Re: SAS VA - Drill down in barchart on SAS Viya

Madelyn_SAS — Wed, 17 Jul 2019 13:40:14 GMT

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?

Re: SAS VA - Drill down in barchart on SAS Viya

Derick — Wed, 17 Jul 2019 13:57:34 GMT

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

Re: SAS VA - Drill down in barchart on SAS Viya

Madelyn_SAS — Wed, 17 Jul 2019 15:48:22 GMT

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.

Re: SAS VA - Drill down in barchart on SAS Viya

Derick — Thu, 18 Jul 2019 02:00:57 GMT

Thanks for the guide, it's work now.