Sum of Revenue Squared

cainej77377828

03-05-2019

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Asheesh_P

MVP

05-05-2019

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))))

1746985_pastedImage_40.png

Calculated Metrics ScreenShot:

1746984_pastedImage_35.png

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