This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

GSC Date Compare doesn't work in table

Posted on 09-24-2024 12:13 AM
RiccardoMares
Bronze 4
Bronze 4
Reply posted on --/--/---- --:-- AM

Good morning everyone. I think I found a bug on Looker Studio with the GSC Connector.
I created a Sparkline Chart based on GSC connector with a date comparison (previous year) and it works well:

RiccardoMares_0-1727161864578.png

I duplicated the same report and changed its type from Sparkline Chart to Table and all the previous year data are missed:

RiccardoMares_1-1727161956965.png

Is it a bug? 
Is there a solution to bypass it (please, I would not use a support spreadsheet)?

Thanks

 

2 2 164
Topic Labels
2 REPLIES 2

Posted on --/--/---- --:-- AM
kevinpadilha
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hey Ricardo!

I can help you with this question.

The Sparkline Chart probably has a different data format than the table.

From what I can see in the image, it is in day/month, and the table data is day, month and year.

What I recommend is that you choose the display format for your data field, and format it according to how you want to view it. If it is day/month, enter d/MM (respecting the camel case).

kevinpadilha_14-1727196865325.png

I hope I helped and that it works!

0 Likes

Posted on --/--/---- --:-- AM
RiccardoMares
Bronze 4
Bronze 4
Reply posted on --/--/---- --:-- AM

Hi Kevin, thanks for your time.
Both charts have the same date setting: I tried to duplicate the Sparkline Chart modifying only the chart format (to Table) and it didn't work. I also tried to change the date format but nothing.

0 Likes