Question

Stacked bar chart per pivot

  • 30 May 2019
  • 1 reply
  • 2280 views

Userlevel 7
Badge +1

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…


1 reply

Userlevel 3

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

Reply