So I have 3 dimensions: - Year-Month (x-axis) - Barge or truck - Location
1 measure: - Count(distinct container) (y-axis)
In the attached screenshots you can see both dimensions in a separate bar charts. In the 2nd screenshot you can see an attempt where I tried to combine dimension 2 and 3 into 1 dimension, but it looks shoddy. I'd like the months to be combined (the bar charts (locations) next to each other with space to the next month).
So I'd like it like this, basically:
Where the year would be the month in my chart, region the location in my chart and quarter the barge or truck dimension and sum(LineSalesAmount) would be count(distinct container). Surely this must be possible in Qlik Sense?