Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
#ofcalls: Count(distinct User)
avgofcallsbyuser: avg(aggr(Count(Call ID) ,User))
Not if you want something