The end result would replicate this excel graph.
HOWEVER. for some reason I'm struggling to create this combined axis chart, where each colored bar is a different measurement, stacked up next to each other.
The issue I seem to be having is that Date (per month) is my Dimension that I need to use.
So far, I'm doing this:
1) Putting the first measurement to rows
2) Date to Dimensions
3) "Measure names" to rows, left of the first measurement
4) Second measurement to rows
This is what I'm getting, where the two measurements ("monthly total" and "monthly planned total") are NOT stacked next to each other for easy size/color comparison.
As they both have values for the months of 1/20 and 2/20, they need to be stacked side by side, yet they're not.
4 answers
