cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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.

 

Energy1.PNG

 

Energy2.PNG

 

Thanks,

Sud

2 REPLIES 2
Microsoft
Microsoft

Hi @Anonymous,

 

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

1.PNG2.PNG

 

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

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.Source.PNG

 EnergyDetails.PNG

I hope this will help you to understand.

 

Thanks,

Sud

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors