(Your screenshot is very hard to read)
Number of products per user: countd(device)
Average number of products across all users : window_avg(countd(device))
Hope this helps
Thanks for reply
I have attached a database enclosed to help.
your formulas but unfortunately they did not work.
As you will see in document, the number is too large to be correct (over 700 per user ...)
What I would like to have is average number of products per user.
Hope this clears this out