Stables grouped barchart

[Lindea]

Hi.

I am trying to make a stacked grouped barchart.

It have the following variables in my dataset.
- A month variable (Month - Category variable)
- A budget variable (Budget - Measure
- A realized spending (Spendings - Measure)
- A variable that tells me what departement of my company the spending is allocated to (Department - Category)

We have 5 different departements and different budgets in every month in the Company.

I want to make a barchart in SAS VA, that stacks the budgets of the different departements on top of each other for every month (so I can see the departements with Big budgets)

Just beside the total Company budget, i want the realized spendings also grouped by departement. So I can compare how the different departements do, but also so I can have an overall View of the entire Companys spendings in a month.

I have found a similar issue, but cant get it to work:
https://communities.sas.com/t5/SAS-Visual-Analytics/Stacked-and-grouped-bar-chart/td-p/170885

[Madelyn_SAS]

Which version of Visual Analytics are you using, and what problems are you having when trying to follow the other community post? 

[Lindea]

I dont know What version to be fair. But it looks exactly as @MarkusWeick ‘s screenshot

[MarkusWeick]

Hi @Lindea,

is this the kind of graph you are looking for?:

[Lindea]

Hi.

Yes - exactly.

But I don’t have an “Amount” variable.

I only have 4 different variables. In my dataset it could look like this:

Month | Dept | Realized | Budget
6 | A | 120 | 110
6 | B | 110 | 150

And so on.
Therefore I believe that I have to make a custom graph, but I cant Seem to make it work.

[MarkusWeick]

Hi @Lindea 

right, I had to reorganize the data:

Would this be a possible way for you?

[Lindea]

Maybe.

Is there not any Way to do it in sas?

[MarkusWeick]

In SAS there is a way. I'm not yet sure, if you can be done in VA only.

[MarkusWeick]

It can be done in VA. I will describe it later.

[MarkusWeick · Accepted solution]

You can use the “Data Preparation” to do the data conversion.

In a dataquery an additional column can be added to the table and set to 1. Then the new table is saved as “Stackedgroup1”:

Same is then done in a second query and value 2 for the additional column in the table “Stackedgroup2”.

Then the table “Stackedgroup1” is appended by “Stackedgroup2”:

The newly appended table “StackedGroup1” then can be loaded into the Report Builder. With two new calculated Items the needed columns can be created:

Now there are the columns needed for the graph:

[Lindea]

Well. I just tried to do so.

But when I choose the “Group” I can’t assign the variable

[MarkusWeick]

Could you please share a screenshot of data and role details as here:

[acordes]

@Lindea If you don't recognize someone's effort to help you out by giving likes or marking his contribution as solution you will likely end up having a monologue here...

[Lindea]

I am Sorry. I didn’t know how to do it. I think I by mistake marked your as solution

[acordes]

It's fine, don't worry. 

It's not for me, it aims at improving the overall experience and reward those helping hands with applause. 

The SAS community is amazing and let's contribute all to keep this spirit alive.