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