I want to show all months and one custom category created from Month called Quarter values like "Q1" to "Q4"
I want to show these two columns Month and Quater in custom bargraph
By default, it should all months and when the user select Q1 from the drop down it should show something like this in the graph i have attached. Any ideas
how can we do it?
Thanks In advance
Make sure you have two category variables one for quarter and one for month.
Then create a parameter that will contain the value from the drop-down (example: The drop-down contains two values Quarter or Month)
Create a new calculated item that check the value of the parameter and then select which category variabel to use, example och calculation:
IF [parameter] = 'Quarter' then quarter
Use this new item as category in your graph.
In your example you have two different graphs and that is not possible since you can not change visualization upon a value in a list box.
Am I somewhat on it?
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.