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
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?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
May I know how to do a hierarchy data items? I think I'm using the Viya version 03.04
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Thanks for the guide, it's work now.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.