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
1.9K members online now
1.9K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Invalid Formula for Unique Events / Unique Pageviews

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi - I want to create a simple ratio of unique events / unique pageviews in Data Studio. When I create a custom formula: (Unique Events)/(Unique Pageviews) I receive an 'invalid formula error". I tried using the SUM(x) function with both, but received a message stating that reaggregation was not supported. Is there an error in my formula?

Re: Invalid Formula for Unique Events / Unique Pageviews

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

Just tried creating this myself and didn't have any issue.  Screen shot attached.

 

2017-05-26_1236.png

 

Re: Invalid Formula for Unique Events / Unique Pageviews

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

It makes sense, but I continue to receive the invalid formula error. I don't see a difference between my view and yours though.

 

Division Formula Error - Invalid Formula.PNG

 

 

 

 

Invalid Formula for Unique Events / Unique Pageviews

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

The line graph I am using is at a weekly aggregation. However there are some days when the value for a unique event is zero. Could that be causing the invalid formula error.

Invalid Formula for Unique Events / Unique Pageviews

Participant ✭ ☆ ☆
# 5
Participant ✭ ☆ ☆

I wouldn't think so, mathematically it should just return 0.  May be experiencing a small bug since this is a really straight forward calculation, and I was able to recreate it on my end.