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

Inaccurate calculation generated by data studio

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

Hi,

 

I am trying to do a custom calculated field whereby I use case when to calculate count of matching events, divided by the total number of completed goals (tracked by google analytics). Data Studio returns me a very small decimal number (0.00000xxx). I have illustrated my example below:

 

variable1 = COUNT(CASE WHEN REGEXP_MATCH(Event Label, '.*xxx.*') THEN 1 ELSE 0 END)

variable2 = total number of completed goals (tracked by google analytics)

variable3 = variable1/variable2

 

variable3 returns a 0.00000xxx when I view thru a scorecard.

 

May I know the reason why? And how should I go about to obtain the right answer?

 

Thanks in advance!