Average in Drill-down column chart

[Anonymous]

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

[v-yulgu-msft]

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]

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