Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Average in Drill-down column chart

Hi Guys,

 

  I am using Drill-down column chart by ZoomCharts and I found that the average calculation is on the average of each slice and then average of all slices at that level which in terms not giving exact precision of values. 

 

  If you see in my case the hovered bar which is Agile Cockpit Development shows 3.48 but if I drill down to it the actual average I get is 3.54 which display on right top.

 

I tried to get the calculation how it is being done.

e.g. ChildLevel 1 = (1+2+3)/3 = 2

       ChildLevel 2 = (2+2)/2 = 1

       ParentLevel = (ChildLevel1 + ChildLevel2)/2 = (2+1)/2 = 1.5

 

  What I expect at ParentLevel avergae is (1+2+3+2+2)/5 = 2

 

Any solution to get this.

 

 

 

Thanks,

Sud

Need Help

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    In my test, the average value is correct after I drill down to next level.

     

    In your scenario, how did you calculate the [Energy Level]? Please provide sample data to illustarte your problem.

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-yulgu-msft,

       

        My source is in a different format having the hierarchical data.

       

        I am attaching snapshots of source and the average calculation.

       

      I hope this will help you to understand.

       

      Thanks,

      Sud