cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
preetam Frequent Visitor
Frequent Visitor

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?

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Multi KPI 2.1.1

Hi @preetam ,

 

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Multi KPI 2.1.1

Hi @preetam ,

 

Do you mean the logic of calculating the variance? 

Variance is a measure of how widely the points in a data set are spread about the mean. To calculate variance by hand, you take the arithmetic difference between each of the data points and the average, square them, add the sum of the squares and divide the result by one less than the number of data points in the sample.

 

Assume you are given the 10 data points:

4, 7, 10, 5, 7, 6, 9, 8, 5, 9

Find the average, the variance and the standard deviation.

First, add the 10 values together and divide by 10 to get the average (mean):

70/10 = 7.0

To get the variance, square the difference between each data point and the average, add these together and divide the result by (10 - 1), or 9:

  • 7 - 4 = 3; 32 = 9
  • 7 - 7 = 0; 02 = 0
  • 7 - 10 = -3; (-3)2 = 9 . . .

9 + 0 + 9 + . . . + 4 = 36

σ2= 36/9 = 4.0

The standard deviation σ is just the square root of 4.0, or 2.0.

 

Best regards,

Dina Ye

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
preetam Frequent Visitor
Frequent Visitor

Re: Multi KPI 2.1.1

Thanks v-diye-msft for explanation. Have you used this componenet called KPI 2.1.1? It seems it calculates based on some othe logic as it includes time series of data as well . It calculates something based on first and last date.

Community Support Team
Community Support Team

Re: Multi KPI 2.1.1

Hi @preetam ,

 

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

008.PNG

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Community Support Team
Community Support Team

Re: Multi KPI 2.1.1

Hi @preetam ,

 

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 121 members 1,666 guests
Please welcome our newest community members: