topic Re: Stables grouped barchart in SAS Visual Analytics

Stables grouped barchart

Lindea — Thu, 06 Oct 2022 16:11:49 GMT

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

Re: Stables grouped barchart

Madelyn_SAS — Thu, 06 Oct 2022 16:28:44 GMT

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

Re: Stables grouped barchart

MarkusWeick — Thu, 06 Oct 2022 16:46:46 GMT

Hi @Lindea,

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

Re: Stables grouped barchart

Lindea — Thu, 06 Oct 2022 17:29:55 GMT

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.

Re: Stables grouped barchart

Lindea — Thu, 06 Oct 2022 17:30:52 GMT

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

Re: Stables grouped barchart

MarkusWeick — Thu, 06 Oct 2022 17:47:54 GMT

Hi @Lindea

right, I had to reorganize the data:

Would this be a possible way for you?

Re: Stables grouped barchart

Lindea — Thu, 06 Oct 2022 17:51:14 GMT

Maybe.

Is there not any Way to do it in sas?

Re: Stables grouped barchart

Lindea — Thu, 06 Oct 2022 18:20:57 GMT

Well. I just tried to do so.

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

Re: Stables grouped barchart

MarkusWeick — Thu, 06 Oct 2022 18:32:47 GMT

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

Re: Stables grouped barchart

MarkusWeick — Thu, 06 Oct 2022 18:41:26 GMT

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

Re: Stables grouped barchart

MarkusWeick — Thu, 06 Oct 2022 20:01:16 GMT

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

Re: Stables grouped barchart

MarkusWeick — Thu, 06 Oct 2022 20:32:54 GMT

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:

Re: Stables grouped barchart

acordes — Tue, 11 Oct 2022 07:54:07 GMT

@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...

Re: Stables grouped barchart

Lindea — Tue, 11 Oct 2022 08:09:25 GMT

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

Re: Stables grouped barchart

acordes — Tue, 11 Oct 2022 08:45:21 GMT

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.