+2
Hi!
I have a multiple answer survey question about where someone has bought a product. The usual results are: this many people bought at shop A and this many at shop B etc. But what I also want to visualise in a graph (in a CX dashboard) is how many people shopped only in shop A, how many only in shop B and how many in both. Anyone know how to do this?
Best answer by Sachin Nandikol
View original
+21
Hello
Please add a 'Bar chart' and map your multiple-choice question to it. Include data values as depicted in the screenshot below.
Additionally, enable 'Filters' in the chart. This way, whenever you select a particular bar (e.g., Shop A), the entire dashboard will automatically filter accordingly. This functionality extends to other options as well.
Let me know if this helps.
+2
Thanks
This is already helpful, but then I see the total of people that shopped at Shop A. What I want is in one graph:
I think I need a custom metric for that, but can't figure out exactly how the formula should look like.
+21
Hello
You can implement this by adding a branch and setting up logic as follows: If "Shop A" is selected, add an embedded variable (e.g., "Shop A"). Repeat the same process for "Shop B" and another variable (e.g., "Shop B"). Map these two variables in your dashboard source. Then, you can use these variables to formulate expressions like the ones below:
Let me know if this helps.
+2
Yes, that worked. Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.