Sum of Revenue Squared

[cainej77377828]

Performing some offline A/B confidence testing using calculated measures.  Therefore, can't use Target lift and confidence.

Found an Excel calculator that uses Sum of Revenue Squared as an input.  Is there a way to use calculated measures to create Sum of Revenue Squared?

[Asheesh_Pandey · Accepted solution]

Hi,

Yes! we can certainly get this in calculated metrics.

Calculated metrics for Variance A -

Summary:

fx (column sum ( fx ( Power operator (metric_X (Revenue) metric_Y (2))))

Calculated Metrics ScreenShot:

Note: You may need to apply a segment on top of it get Sum of Revenue for Variance A. only if using segment for Variance A Total Revenue and Variance A number of Uniques.

Thanks,

Asheesh