Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Multi KPI 2.1.1

I recently Downlaoded it and used to for one of production dashboard to calculate variance . However, somehow still confused as to how its calculates variance and by which logic percentage changes? ...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    7 years ago

    Hi Anonymous ,

     

    If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

    Best regards,
    Dina Ye

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Oops, just got your point. you mean the variance rate . The rate was calculated by (the value on the last day)-(the values of the first day), then divide (the value of the first day). Providing that, date is from 2017/1/1 to 2018/6/30, and values is around 44K and 64K, that means the variance is (64-44)/44 in these 2 timestamp ,around 45%:

 

v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,
Dina Ye