topic Bar Chart- Stacked+ General in SAS Visual Analytics

Bar Chart- Stacked+ General

SASEnthusiast — Wed, 24 Feb 2016 22:38:29 GMT

Hi,

Is there a way to create a Stacked plus a general bar in SAS VA.

I have three capacities:

1. Budget Capacity

2. Available Capacity

3. Allocated Capacity

where, Budget Capacity= Allocated Capacity + Available Capacity

I wish to make a graph in which each category has two bars. One for budget capacity and the other stacked one for Allocated + Available.

Re: Bar Chart- Stacked+ General

TejaSurapaneni — Thu, 25 Feb 2016 08:55:52 GMT

Hello SAS Enthusiast,

I have some stuff for you,

Hope this will help,

Let me know...

Thanks & Regards,

Teja Surapaneni

Re: Bar Chart- Stacked+ General

SASEnthusiast — Thu, 25 Feb 2016 14:38:50 GMT

Hi Teja,

This is really what I need. Could you guide me towards the steps for this?

Also, can the aggregation (as in yours) be a predefined column and not a calculated column?

Re: Bar Chart- Stacked+ General

Lodewijk — Thu, 25 Feb 2016 14:44:40 GMT

Hi SASEnthusiast,

You can create the graph you want with the Custom Graph Builder. You can put two bar charts on top of eachother and have them share the category (x-axis). Initially it looks like this:

Bar Chart 1 allows multiple data assignments by default, Bar Chart 2 doesn't. You can change this by editing the Role for Bar Chart 2 Measure if you like. For stacked charts you obviously need multiple assignments 🙂

Now to show them next to eachother, play around with the properties.

Under Plot Display, for bar chart 1 set the bar spacing to something like 65 and set the discrete offset to -20 negative. This makes a slimmer bar and pushes it to the left. Do the same for bar chart 2, but with a positive offset to push it to the right. You'll see that they are next to eachother.

Under Groups, set the grouping style to "Stack" for the bar chart you want to have stacked.

Now save it and use it in the report. Assign the budget capacity as the measure for the unstacked chart, and the Available and Allocated as the measures for the stacked chart.

Re: Bar Chart- Stacked+ General

SASEnthusiast — Thu, 25 Feb 2016 15:41:25 GMT

This works beautifully. Thank you so much.

Re: Bar Chart- Stacked+ General

AnnaBrown — Thu, 25 Feb 2016 18:35:10 GMT

I'm glad you found some useful info, SASEnthusiast! Can you highlight the exact solution to your problem by "Accepting it as a solution"? And if one was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.

Thanks!
Anna

Re: Bar Chart- Stacked+ General

Joy_SAS — Thu, 25 Feb 2016 21:22:50 GMT

For more information about SAS Visual Analytics Graph Builder, see Creating and Using Custom Graph Objects in the SAS Visual Analytics 7.3 User's Guide. (A similar chapter is available in the 7.2, 7.1, 6.4, and 6.3 user's guides.)

-Joy