Stacked bar chart per pivot

Question

I’m having trouble building a bar chart that would have few categories and in each of them a metric should be split by a pivot.
For example I have number of sessions and two dimensions:
time: this week, last year
type: new, returning

I would like the barchart to look like this:
 _____
|new  |
|_____|
|ret  |
|_____|

and this bar chart to be repeated by pivot: last year, this year etc.
I can’t achieve that. I create table with new/ret as dimension and few measures (last year, this week etc.) but I can’t make the bar charts to be split by the category… any thoughts?
– edit
Now when I think about it, it would be pretty easily accomplished if we had transposition…

DaanIF · Answer

Hi Dawid,If you have a dimension that splits timestamps and one that splits the type, it should not be a problem to achieve this.What is the measure you are using?If you put in - for example - a date_year-field as a regular dimension with a filter on the past 2 years.Then add the type as a pivot.Add the measureChoose Bar VisualisationUnder Edit, click on StackedOr am I missing something?If you want to transpose measures, I coincidently just read an article on that:              Transpose Table (Display measures as Rows) Table Calculations        The GoalSay you want to transpose your table; that is, show the measures as rows. That is, if your data looks like this:  [step 1 - vanilla]The goal is to show all the different Count measures grouped together, rather than all the Years grouped together. This is possible by using dimension fill to manufacture some rows, and then using a table calc to fill in those manufactured rows. The finished product will look like this:  [step 4- done]The ProcessStep 1: Case DimensionMake a dummy cas…  Kind regards,Daan

Stacked bar chart per pivot

1 reply

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded