Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, guys!
I have a table:
ID | Product |
1 | Swimming |
2 | Swimming |
1 | Crossfit |
3 | Swimming |
3 | Running |
2 | Power lifting |
1 | Power lifting |
2 | Running |
2 | Spa |
So as we can see:
ID 1 has 3 Products,
ID 2 has 4 Products,
ID 3 has 2 Products.
Avarage, it's 3 products for 1 ID.
Question is: How can I calculate this task in KPI chart, find avarage count of Products by 1 ID (if I have thousands of IDs and several Products)?
Please help with that)
Thanks!
=Avg(Aggr(Count(ID), ID))
Thank you so much!
I didn't know that func before)
But as I understood correct, I edited your expression: Avg(Aggr(Count(Product), ID))
=Avg(Aggr(Count(ID), ID))
Thank you so much!
I didn't know that func before)
But as I understood correct, I edited your expression: Avg(Aggr(Count(Product), ID))