How calculate how many user has done the same number of order.

[#1]

Hi all,

i have a problem calculating the number of user that have done an order.

How i can calculate the next scenario?

USER,   NUMBER ODER

a               10

b               4

c               3

d               10

e               3

I know that there are two user that have done 10 orders, two user that have done 3 orders and one that has done 4 orders.

USER      NUMBER ORDER

2               10

2               3

1               4

The number od order is calculated with count(id_order) but how i can calculate the user?

[#2 · Accepted solution]

Just create the Chart with below Dimension &  expression:

Chart Type: Any

Dimension: OrderNumber

Expression: Count(USER)