In Explore, I am trying to create a standard calculated metric that outputs the difference between the average of 2 other metrics, both of which are date range calculated. However, using AVG[metric1]-AVG[metric2] is outputting a number that is not equal to the difference between the 2 averages.
In the attached screenshots, I expected that the metric represented by the orange bar would display the difference between the other two bars, as I tried to configure in the attached component setup. Can you please review and help me understand why the configuration attached does not display the difference between the two components/how I could achieve that setup?
Post is closed for comments.