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]