We’re smarter together. Learn from this collection of community knowledge and add your expertise.

Keep your SAS Visual Analytics charts in sync through shared roles

by SAS Super FREQ on ‎12-18-2014 10:23 AM - edited on ‎10-05-2015 04:24 PM by Community Manager (1,272 Views)

Since the first release of SAS Visual Analytics Graph Builder (VA Graph Builder), available with SAS Visual Analytics 6.3, I’ve been amazed about the number of interesting charts that we can create by customizing existing ones, or combining them into a totally new chart. Every time I see a chart that looks different, I wonder if I can create something similar with VA Graph Builder, and very often I’m pleased with the results.


Recently I learned that VA Graph Builder can be used for something that I had not noticed before: you can use it to keep two or more charts in sync as you drill up or down into the hierarchy. The secret to accomplish that is very simple: shared roles.


In the example below, I added a pie chart and a treemap side by side. In the Role Definitions tab I’ve created and assigned a shared role for both the pie chart category and the treemap tiles. That’s all!


Figure 1 - Graph Builder.png

Figure 1 – Pie chart and treemap side by side in VA Graph Builder


Figure 2 - Graph Builder Roles.png

Figure 2 – Shared role assigned to pie chart and treemap in VA Graph Builder


You can now go to Visual Analytics Designer, add the new custom chart and assign the roles. In this example, I’ve used the Products Hierarchy as the shared role.


Figure 3 - Designer Roles Assignment.png

Figure 3 – Example of roles assignment in VA Designer


Both the pie chart and the treemap are drillable – and drilling into one of them will also affect the other, keeping them in sync. Easy and powerful.


Figure 4 - Designer Report.png

Figure 4 – Example of VA Designer report with hierarchies in sync


I was already a big fan of VA Graph Builder and things like this just make me feel like exploring it even more. Happy graph building!

Your turn
Sign In!

Want to write an article? Sign in with your profile.

Looking for the Ask the Expert series? Find it in its new home: communities.sas.com/askexpert.