Show comparison periods in bar chart

I have a problem with Looker Studio that I cannot solve. I would like to display my KPIs (e.g. impressions), e.g. for Google Ads, in a bar chart as follows: 1st column: impressions in the selected period, 2nd column: impressions in the comparison period. Can I display this somehow? Thank you in advance!

0 1 52
1 REPLY 1

Hi @freddy_schuetz ! 

I'm a bit late here, but I can share some thoughts. Studio has a handy "comparison date range" feature but that's only available for certain chart types. For a bar chart, I think you'll have to create a calculated field that specifies your date ranges (and do your best to use syntax that makes these relative.)  Here's an example: 

Screenshot 2024-05-17 at 9.51.38 AM.png

Screenshot 2024-05-17 at 9.52.04 AM.png

If anyone has a snazzier way of doing this, would love to see it! 

Top Labels in this Space
Top Solution Authors