Forum Discussion

baumad2's avatar
baumad2
New Member
10 years ago

kpi calculations

I am trying to create a KPI which shows the scores for a Work Variance, by customer and project.  I have been successful in creating a goal (10% variance and under), however, the indicator, though set to show an average, is showing a calculation I cannot justify or understand.  

 

For example, for a particular customer, I have 6 projects.  The scores are: 0.000573, 1, 1, 1, 1, 0.01543.  The average is 0.6693.  However, the KPI shows the score as 0.02. Is it just reading the last score, alphabetically by project name?

 

I verified the data it was reading by exporting to excel.  I have tried recreating the KPI, by changing the order in which I add the indicator, trend and targets.  Is there not a way to show a cumulative score for a group of projects, based on the applied filters?  I tried changing the indicator to sum, average, median, etc, but nothing reflects a relevant score. 

 

Any help or suggestion would be appreciated!

 

Here are screen shots of the data & settings:

 

 

3 Replies

  • chrisu's avatar
    chrisu
    Icon for Responsive Resident rankResponsive Resident
    10 years ago

    This has been my experience with the KPI visual as well--it seems to be designed to show a trend showing the last/most recent data point, which in your case is Project F.  I haven't tested this, but I'm thinking you could override the filtering by project by adding another measure with an ALL, like this:

     

    AvgMerWorkVar = CALCULATE(AVERAGEA([MerWorkVar]), ALL([Project]))

     

     

    • julbla's avatar
      julbla
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      If you use chrisu's solution, the KPI will no longer show a trend line. What baumad2 really needs is two seperate charts - a trend line chart, and a chart for the cummulative calculation.