CODEWITHSUNDEEP
dategoogle-sheetschartsgoogle-visualizationlooker-studio
Faza HA
Faza HA

Reputation: 11

Show annual or monthly chart using google data studio

I have data on the date_created of our members with DDMMYYYY format. I want my chart in MMYYYY format when I selected A year timeline or a few months' timelines. But I want my data in DDMMYYYY when I selected a month timeline. How could I do that?

I want my chart would be like this :

Lifetime Timeline:

Lifetime Timeline

One-month Timeline:

One-month timeline

I made this manually using 2 fields.

Upvotes: 1

Views: 3218

Answers (1)

Minhaz Kazi
Minhaz Kazi

Reputation: 3168

Have you tried changing the Granularity of your time field?

enter image description here

Upvotes: 1

Related Questions