Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.