Show comparison periods in bar chart

[freddy_schuetz]

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!

[quinn_morrison]

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: 

 

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