How to present compared with last period and last yeat

Looker Q&A Looker Studio
1

I have a date selector controlling a number field

I want to show the field compared to last period but also compared to same period last year.

I can of course have two fields but it looks a but silly showing the same metric twice and then two comparisons

Ideas?

2

Agree, I wish LS accommodated this better.

What I do is create a calculated metric for last period gain and a calculated metric for last year gain and then a table like:

metric,value,last period gain,last year gain

clicks,100,10,20

…and of course you can add conditional formatting and such.

So then it’s a scorecard table.