Show chart object with fixed pre-selected response from another question

[#1]

Hey guys,

Hope you all doing great. I had a question and i was wondering if you could help me out,

I have two questions in my data:

1. What is your gender?

- Male

- Female

2. Do you like oranges or apples?

- Apples

- Oranges

How do i make a bar chart which shows Gender (both male and female) for only those who bought apples?

This selection (apples) should be fixed only for this chart object. The other charts must not be affected by this selection.

Thanks a lot guys!

[Gysbert_Wassenaar · Accepted solution]

Assuming you have a field Customer and a field Product you can use this expression: count({<Product={'Apples'}>} Customer)

Change Customer and Product as appropriate to your situation. Use Gender as the dimension for the chart.

[#3]

Thanks a lot mate. I managed to figure it out from there.