Data Studio
2K members online now
2K 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

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

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

Explorer ✭ ✭ ✭
# 5
Explorer ✭ ✭ ✭

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.