topic Drill down across multiple graphs in SAS Visual Analytics

Drill down across multiple graphs

sseanhennessyy — Wed, 09 Nov 2016 20:41:55 GMT

Let me preface by saying I'm not sure if this is even possible in SAS VA. I have three seperate graphs on a report all of which utilize the same heirarchy. I would like it so that if you drill down in one of the graphs, the other two will drill down as well. This way you wouldn't have to click on all three graphs to get the desired visualization.

If there is no way to do this, another thought I had was to have a button bar or dropdown which would let you select the desired drill down level you wanted to see.

Anyone know a way to do either of these?

Re: Drill down across multiple graphs

TejaSurapaneni — Thu, 10 Nov 2016 05:39:58 GMT

Hi,

Which object's you are using..?

have a look on this..

https://communities.sas.com/t5/SAS-Communities-Library/Two-ways-to-split-bar-charts-in-SAS-Visual-Analytics/ta-p/224002

hope this will help... 🙂

Thanks & Regards,

Teja Surapaneni

Re: Drill down across multiple graphs

sseanhennessyy — Thu, 10 Nov 2016 15:24:18 GMT

Thanks for the quick reply!

Unfortunely I don't think that article will help with what I'm trying to do, although it is a good read and I will likely refference it in the future!

For this I have 3 different pie charts that show different metrics and a hierarchy over them that starts at state level and goes down to different product types. I'm hoping to have it so that if I drill down on one of the pie charts, the other two will drill down as well thus eliminating the need to click and drill down on each pie to see the product level for the different metrics.

Re: Drill down across multiple graphs

vivek_sas — Mon, 14 Nov 2016 11:31:07 GMT

Hi,

It can be achieved if you create a custom graph .

1)In custom graph first select multiple pie charts based on your requirement.

2)create one shared rule for category

3)apply that shared rule to all graphs which you selected.

If you use that custom graph in report...category will be same for all graphs and you can select different measure for each graph seperately.then you drill on one graph all graphs will drill.

In the above i createted one shared rule - Shared rule 1

and applied it to all piecharts in the place of category

Regards,

Vivek R