AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Aggregatition for months

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

If I wanted to create the following table with Sessions, how can I do this?

 

If I use the formula as new metric and add new: SUM (CASE WHEN Month of the year = "January" THEN 1 ELSE 0 END), it doesn't work.

 

Search.JPG

Aggregatition for months

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi Gabriela,

 

I would make a copy of your date dimension that just shows the month, then use this in your data grid to replicate the above.

 

Hope that helps,

Ben

Re: Aggregatition for months

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Hello Ben,

It would not allow it as it adds an extra column. In Metrics I cannot add it as you can only add dimensions

[cid:image001.png@01D2BD1C.09910A80]
[cid:image002.png@01D2BD1C.09910A80]