Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, would love to hear your ideas for my problem
This is my table:
Customer |
Product |
Bought it or not |
A |
1 |
1 |
A |
2 |
0 |
A |
3 |
0 |
B |
1 |
1 |
B |
2 |
0 |
B |
3 |
1 |
C |
1 |
1 |
C |
2 |
0 |
C |
3 |
1 |
In my dashboard I put the product column into a filter panel and I want to create a KPI that count the number of customer that bought the product.
For example: When I choose product 1 and 3, I want the kpi to show 2 because there are only 2 customers that bought product 1 AND product 3 (costumer B and costumer C)
Any idea how can I do this?
Thanks a lot!
as below
=Count({<Customer={"=sum(BoughtIt)=Getselectedcount(Product)"}>} Distinct Customer)
"can i count also only the customer the bought this 2 product only? (and didn't buy any of the other products)"
that would as below
=Count({<Customer={"=count({<Product=>}distinct Product)=Getselectedcount(Product)"}>} Distinct Customer)
you can use the same expression, replace Customer with ID
=Count({<ID={"=count(distinct Product)=Getselectedcount(Product)"}>} Distinct ID)
as below
=Count({<Customer={"=sum(BoughtIt)=Getselectedcount(Product)"}>} Distinct Customer)
Hey! Thanks a lot omg!
it looks like its working great. still need to do some validity test but its looks great!
At the moment, its counting all the customer that bought this 2 product and other products as well.
can i count also only the customer the bought this 2 product only? (and didn't buy any of the other products)
*i didnt upload the full table but in my original table i have more the 3 products and it will be nice to know which customer buying only a specific products
Tahnks alot!!
"can i count also only the customer the bought this 2 product only? (and didn't buy any of the other products)"
that would as below
=Count({<Customer={"=count({<Product=>}distinct Product)=Getselectedcount(Product)"}>} Distinct Customer)
Hello,
would like to ask last question about this issuse please
I Changed my table so now its looks like this:
ID Product
1 1
1 2
1 3
2 2
2 3
3 1
4 1
4 2
4 3
5 2
I want to create the same KPI that will count only the ids that have all the product that i choose.
For example: when i choose product 1 and 2, and i want the kpi to count 2 (because there are 2 ids that have both product 1 and 2)
any suggestion how can i make it?
Thanks alot!!!!
you can use the same expression, replace Customer with ID
=Count({<ID={"=count(distinct Product)=Getselectedcount(Product)"}>} Distinct ID)
Working Great!
Thanks alot.