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
Community 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%:

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-diye-msft  Hello , thanks for your explanation, I want to see if there is a way to chang the percentage calculation.

For example, the top I show the actual sales, bottom show the target sales, and the percentage I want show the actual sales/ target sales, which means how many sales have achieved. Is that possible? thank you