So I basically want to do what I drew here. I have two databases, one measures two types of expenses within a month and the other is my projection of the expenses. I want to compare them side by side using the stacked chart, but it doesn't seem to allow me to have two different metrics for the same dimention (MONTH). i'm not really sure how to combine the databases either.
You are correct- a stacked bar chart can only support a single metric. You can't have breakdown dimensions and multiple metrics in the same chart.
Maybe make two different charts - one per database? And then put them side by side or top over bottom for comparison.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |