Data Studio
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How to group dates by decades or other custom periods?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I would like to create a bar chart. I want every bar to correspond to a decade (Ex '70s, '80s, '90s). My raw data is now in the classic format (GG/MM/YYYY HH.MM). Is it possible to do it inside Data studio? 

What if I want to group by customised periods (Ex. Year ranges 1960-1975, 1976-1980, 1981-1999), is it possible?

How to group dates by decades or other custom periods?

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Guillaume T

 

Unfortunately, as far as I am aware, you cannot create this custom date format within Data Studio at the moment.

 

Your option would be to add this at the data level so you could show yearly data in chart.

 

Hope that helps,

Ben