How can I compare values on a yearly or quarterly basis on Lookerstudio?

The monthly comparison works fine, but as soon as I change the time period to yearly or quarterly, Looker Studio either doesn't calculate anything or gives incorrect values.

Bildschirmfoto 2025-01-16 um 18.15.19.pngBildschirmfoto 2025-01-16 um 11.23.06.png

2 REPLIES 2

Hi @Esra4793
Is the goal is to show quarterly average value for an NPS and compare it to previous quarter?

Regards
Arkady Zagdan

 

Hi @ArkadyZagdan 🙂 

First, I’d like to understand the timeline that I pinned to my dashboard. In the top right corner, I have a calendar, and when I try to compare October values with December values, none of the scorecards update—only two of the sparklines (which I marked in the screenshot) change.

Next, I’d like to compare Q4 (the average of October, November, and December) with Q1 in a structured way. So, I actually have two questions for you! 😄

Bildschirmfoto 2025-01-18 um 23.16.40.pngBildschirmfoto 2025-01-18 um 23.17.26.pngBildschirmfoto 2025-01-18 um 23.17.45.png