Average issue (super simple for pros i think)

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

image

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

2 Likes

For reference:

1 Like

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.

2 Likes

AVERAGE


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.

1 Like