Data being filtered differently in line chart and area chart
I have the problem that from the same data source (Google Analytics) a line chart displays differnent data than an area chart.
I have a custom dimension that is defined like this:
CASE WHEN REGEXP_MATCH(Product SKU, "SOMEREGEX") THEN TRUE ELSE FALSE END
Now, for the carts, my dimension is "Date"
My Drilldown dimension is my custom dimension as stated above.
My metric is revenue.
If I now display the line chart, I get two lines for "true" and "false" over time with the correct values.
I would like to have them stacked now - therefore I also added an area chart (with stacked option on) and added the same dimensions and metrics to this chart.
But now only one line is displayed for "true" and no area is displayed for false.
Is this a bug or am I doing something wrong?
I expect both charts to be the same data - just a different visual representation.