nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Chart based on crosstab with multiple dimensions

mogwai

I have a crosstab with 2 dimensions on the rows: district and type.
There are always 2 types (intervention and control) so I have 2 rows for each district.
A screen shot of the cross tab is attached.
I would like to create a chart that has Y-series grouping for every row in the cross tab, but I can only select one of the dimensions for the Y-series grouping and whichever I choose (district or type) I always get grouping on the first value for district (see second screen shot).
Is there a clean way to break the chart down with one line per crosstab row?

Find more posts tagged with

Comments

mwilliams

Are you looking for something more like this?

mogwai

Hi Mike, 
 
I did try that but that didn't work. The result is attached. 
 
I'm working from a crosstab and not a table. The expression I used in the Y-series grouping is 
data["district"] + " - " + data["type"]

mwilliams

I am working from a crosstab as well. I fixed the typo above (row -> data)
 
Attached is the report and xlsx file of data I used to create my dataset and data cube.

mogwai

You're an ace Mike. Thanks to your example I could see what I did wrong. I had not created Type as a level in the same group as District but as a group on its own. In the crosstab it gave the same result but in the chart it didn't work.
You went to a lot of effort to recreate this. I really appreciate it.

mwilliams

Not a problem at all. Always glad to help!