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

Aggregate daily data into monthly data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

We are pulling data daily in order to have the report filter correctly for our other metrics. However, we want to put a table that aggregates the daily data into months for each row to show a month-over-month comparison. Is this possible?

Aggregate daily data into monthly data

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hi Darien,

 

did you find a solution? 

Having the same problem.

 

Best

 

Alexander

Aggregate daily data into monthly data

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭

Not sure what data columns you have but wouldn't dropping the date column and instead use a month column works?

Aggregate daily data into monthly data

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Hi,

I did this by flowing these steps :

  0 - we suppose the date variable (named: date) has this format (YYYYMMDD) ;

  1 - creating a copy of date variable (named: copy_date) ;

  2 - change the format of the "copy_date" to (YYYYMM) ;

  3 - use "copy_date" in the chart as dimension ;

  4 - use "date" in the chart as date range dimension ;

  5 - choose an other variable numeric as metric.

 

It is all you need, easy isn't ?!

 

regards

A.DANBA

 

Aggregate daily data into monthly data

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi,

 

yes. That works fine Smiley Happy

 

Thanks