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

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

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