calculated metric not calculating
RespondidaIn 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?
Thank you.
-
Hi Lionel!
Instead of creating the sum via a standard calculated metric can you give a result metric calculation a try to see if this gives more accurate results? Result Metric Calculation allows you to add a further calculation to a query. This is explained with instructions on how to set it up here!
Using result metric calculations
Let me know your results!
Por favor, entrar para comentar.
1 Comentários