Average issue (super simple for pros i think)

NoobStarter
Participant II

Issue is “Average” doesnt work for numbers
for example average for:
4
4
gives average 2, but it should be 4…

Solved Solved
0 6 248
  • UX
1 ACCEPTED SOLUTION

3X_9_1_91a290165fd2a580eff32a161219a8380b367d0d.png

Seems to work fine here. You’ll have to further describe your issue if you’re seeing different.

View solution in original post

6 REPLIES 6

3X_9_1_91a290165fd2a580eff32a161219a8380b367d0d.png

Seems to work fine here. You’ll have to further describe your issue if you’re seeing different.

Steve
Participant V

For reference:

NoobStarter
Participant II

Still issue:
I think its counting empty cells as 0.
Hove i can skip / not take empty cells to average output? I mean if i have for exmpl 3 rows
2
Empty cell
3
Id like to have result 2,5 without 0 on row 2…

Please post a screenshot of the complete expression you’re using.

3X_9_0_902e2fdf85d1e358859e256ae3b0d00335cd3020.png


So its just simple chart, no expressions yet.
Problem is when i add those 4 and 3 numbers i should get 3,5 average, but now its counting empty cels as zero, i think, so average its lover and lover every time empty celss appear. Because students dont haveto add numbers every time…so i think it should have something like “countifnotblank” like expressioins…

I suggest making a Slice for only those records with values, then basing the Chart View on that Slice.

Top Labels in this Space