Hi,
I have created a table that contains 5 metrics out of which two are in % form using show value as %of metric feature. Thw view that i created is two versions in column and variance also. The problem that i am facing is variance for 4 metrics is coming correct except 1
i.e. out of the 2-percentage based metric variance for one is coming correct but other is not though both are using same methods and individually for each version values are coming correct. Unable to find a reason why only one is inconsistent although at individual version level it is coming correct.
Please let me know what i am doing wrong.
Thanks in advance
Solved
Variance 5 wrong for one metric and right for another
Best answer by Min Li
Did you checked the order of the calculated items here? Sometimes, the order matters if it doesn’t produce the right number.

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.


