A Friday Count

[#1]

Hi All,

It is Friday and almost end of the working day... It seems that my brain stopped working already... Can you please help.

I have the following table

Call ID	User
1	1589788
2	1590144
3	1590500
4	1589788
5	1593375
6	1593731
7	1594087
8	1589788
9	1590144
10	1590500

I need to count for the Distinct user the number of call made... I can't list all the user as let say there is maybe 100 000 of them. same applies for the ID...

Then I'd like to find out the average per user as-well...

I am pretty sure it is straight forward, but not on a Friday...

Thank you,

Maxime

[Clever_Anjos]

#ofcalls: Count(distinct User)

avgofcallsbyuser:  avg(aggr(Count(Call ID) ,User))

[#3]

Not if you want something