Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there any known issue about the avg function?
I have a field that count days per code. The think is that if in a pivot table I have this expression:
Avg(distinct Days) and has as Dimensions Name, store, code and Days.
The pivot table displays the fields properly, the avg is not correct for a few of them and I don't know why.
I have tried to do it manually
Sum (distinct days) / Count (distinct Codes)
But the results are not well neither.
Any idea?
Can you share a sample to work on?
I am sorry, I cannot do that
You can scramble your data and upload like mentioned here:
Preparing examples for Upload - Reduction and Data Scrambling