Data Studio
2.1K members online now
2.1K members online now
Ask questions about Data Studio
Guide Me

Inaccurate calculation generated by data studio

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



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!