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
