1 out of 5 chart

[#1]

Hi.

You got five products (1 2 3 4 5) - Each has its own button. When you select one product a chart will display the numbers of customers who got:

• only that product
• That product and One other product
• That product and Two other products
• That product and Three other products
• That product and Four  other products

The logic is this:

Selected product - Only that one

(2) Selected product - 1 or 2 or 3 or 4

(3) Selected product - 1 or 2 or 3 or 4  AND 1 or 2 or 3 or 4

(4) Selected product - 1 or 2 or 3 or 4 AND 1 or 2 or 3 or 4 AND 1 or 2 or 3 or 4

(5) Selected product - 1 or 2 or 3 or 4 AND 1 or 2 or 3 or 4 AND 1 or 2 or 3 or 4 AND 1 or 2 or 3 or 4

Can anybody help me with the expression, and/or the logic to solve this puzzle?

[MK_QSL]

Can you provide some sample data?

[#3]

Here is some sample data.

It is not the best example, but hopefully it will show the essence of what im going for

[#4]

It would be very helpful if someone could take a look at this

[#5]

Anyone?

[MK_QSL]

Let me try... but need your exact result... don't understand what you want to get...

[#7]

Each person has 1-5 foods. (can have one, or more)

I want to make a chart that displays how many ppl have just one type of food (of any kind), how many people have two kinds if food (of any kind), the three and so on.

Thanks for the help, let me know if you have any questions or I can do anything

[#8 · Accepted solution]

Maybe like attached. I change the data model a bit and did the calculations on the backend.

Thanks

AJ

[MK_QSL]

Good Solution provided by Ajay at Script end... But if you want to try at UI end, use as below suggested..

Create a Bar Chart or Straight Table....

Dimension

=Aggr(COUNT(DISTINCT Food),Name)

Expression

COUNT(DISTINCT Name)