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?
Now when I think about it, it would be pretty easily accomplished if we had transposition…