Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

average of group by

hello
I have a question about average with the group by
here is a sample from my data

rootsubquestionsscores
CC.1C.1.10
CC.1C.1.230
CC.1C.1.3100
CC.1C.1.40
CC.1C.1.570
CC.2C.2.10
CC.2C.2.20
CC.2C.2.390
CC.2C.2.40
CC.3C.3.1100
CC.3C.3.20
CC.3C.3.340
CC.4C.4.10
CC.4C.4.259
CC.4C.4.330
CC.4C.4.490
CC.5C.5.120
CC.5C.5.20

so I have the root C then the branches
I need to get an average of each sub by use chart drill down
as you can see here is the result I got bu used zoomcharts advanced donut visual p1.png

 

it takes the average of the root based on overall branches but if I drill down the average of branches is correct but the root is not. 
here is an example for more explain
if I take the average of root C as here
(0+30+100+0+70+0+0+90+0+100+40+0+59+30+90+20+0)/18= 34.94
but if I take it by the group first the result is different
c.1=40
c.2=22.5
c.3=46.66
c.4=44.75
c.5=10
(c.1+c.2+c3+c.4+c.5)/5=32.7
and on the chart, C = 34.94 means it takes the average by overall
is there any chart or way to make it take the average for the group first?

2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Actually, the average will be calculated based on the all number rather than the grouped one, why will you calculate the average of the grouped one directly?

Best Regards,

Teige

Anonymous
Not applicable

because I think this way is more accurate than the other
c.1=40
c.2=22.5
c.3=46.66
c.4=44.75
c.5=10
(c.1+c.2+c3+c.4+c.5)/5=32.7

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors