Stacked bar chart per pivot

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…

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?

  1. If you put in - for example - a date_year-field as a regular dimension with a filter on the past 2 years.
  2. Then add the type as a pivot.
  3. Add the measure
  4. Choose Bar Visualisation
  5. Under Edit, click on Stacked

Or am I missing something?
If you want to transpose measures, I coincidently just read an article on that:

Kind regards,

Daan

1 Like