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?
Yes! we can certainly get this in calculated metrics.
Calculated metrics for Variance A -
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.