Average of rows doesn't add up

[pedromsouza]

Hi,

I'm working on a pivot table with an aggregated expression. For the total, I need the average of rows, but it's returning a much smaller number.

Sample:

Date Day Count
01/07/2021 Qui 1,866
02/07/2021 Sex 840
03/07/2021 Sáb 898
04/07/2021 Dom 122
05/07/2021 Seg 1,907
06/07/2021 Ter 1,838
07/07/2021 Qua 1,918
Avg 303

Avg should be 1,341.28 instead of 303

The expression is:

Sum(Aggr(Count({<ind_smm={'E','L'}>} Distinct p_id)
,date,venue,weekday)
)

Dimensions:

date(date)

weekday

Please help me figure this out!

[PiEye]

Hi Pedro -can you also share the expression in the first table (the non-aggregated one?)?

Your expression should work, so I wonder if it is the opposite, something to do with distinct count etc.