Calculating a Mean Value on Dimension Values

[marion33678522]

Hello Adobe Community !

I'm currently stuying the values of a conversion variable - and would like to calculate the mean value.
I've already done this with the visits, but this is diferent since I can't use any dimension on the Calculated metrics tool. I just can get the Instances of that dimension, but the mean has nothing to do with the mean of my dimension values :

Is this possible ? to multiply each value of a dimension by the number of instances ? Or I have to extract via the Datawarehouse and do the calculus with another tool ?

Kind regards,

Mario

[Løjmann · Accepted solution]

Hi Mario,

You can't use a dimensions value as part of a calculated metric, instead you can change your implementation to set the value of the dimension to a custom event as well, and the use that event to make your calculations on.

/Løjmann

[marion33678522]

Nice !
That's a very good idea ! Thanks a lot Løjmann !

Løjmann

Kind regards,

Mario