Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am trying to create a grid chart but I get the following result: "Error in Calculated dimension".
I'm not sure what I'm trying to achieve can be done so I'll be happy to get your comments on this.
I want to have 2 dimension: one is the App name and the other is a variable called vConversion, which is calculated by sum(installs)/sum(clicks).
When I define this as a calculated dimension, I recieve the above mentioned error.
Is it possible to define such a dimension? If so, how can I resolve this error?
Thank you,
Ella
Hi,
maybe you have to aggregate by App name.
Try =aggr(sum(installs)/sum(clicks),AppName)
Hi Gysbert,
I tried =aggr($(vConversion), name) and it worked.
My only question is, doesn't that function change what I wanted to achieve?
Is the calculation being performed correctly?
On Mon, May 5, 2014 at 1:03 PM, Gysbert Wassenaar
use expression suggested by Gysbert in variable it self and then use variable
hope this helps
If you want the ratio of the sum of installs per app and the sum of clicks per app then the calculation will be correct. The only way to make sure is to check the outcome of the calculations.