Hello,
I have a table like that :
customer | prod_1 | prod_2 | prod_3 |
customer_1 | green | ||
customer_2 | red | orange |
and I would like to count customer by product to get a table like this :
product | count | custumer |
prod_1 | 1 | customer_2 |
prod_2 | 1 | customer_1 |
prod_3 | 1 | customer_2 |
Is it possible ?
Hi @mah,
please try something like this:
your_search
| stats count BY product customer
| table product count customer
Ciao.
Giuseppe
What search produced the first table?