AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.6K members online now
2.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data being filtered differently in line chart and area chart

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi,

 

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.

 

Thanks!