Hello,
I have 3 metrics :
- Capa Test (Dimensions: Macro Ressources, Mois)
- Charge Test (Dimensions: Macro Ressources, Macro Item, Mois)
- Saturation Test (Dimensions: Macro Ressources, Macro Item, Mois) : Saturation Test = Capa Test / Charge Test
But as you can see, when I use a multi-selection, the KPI “Saturation Test” doesn’t display the expected result (which would be 132/185 = ~71%).
Do you know how I can aggregate this formula in order to have the expected result ?
Thank you very much
+12HI
I would suggest using Show Values As to compute the % for saturation test instead of a normal formula.
A normal formula only computes at the lowest level, and then aggregrates.
Hi
I would like (when a do a multi-selection) the result to be displayed as :
- average regarding the dimensions Mois and Macro Ressource
- sum regarding the dimension Macro Item
Is it possible to display it this way ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
