Inaccurate calculation generated by data studio[ Edited ]
June - last edited June
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!