Hi everyone,
I have some data around complaints from users. Their complaints are sorted into categories, but one complaint can be assigned multiple categories. These categories are stored in a column and are seperated by a comma if there's more than 1. It looks like this:
| id | category |
| 1 | Technical |
| 2 | Technical,Guidance |
| 3 | Customer Service |
| 4 | Guidance |
| 5 | Technical |
| 6 | Technical |
| 7 | Customer Service,Technical |
What I want to do is to be able to create a slicer where the user can select any of those categories and filter to the relevant id, but I don't want combined categories like "Technical,Guidance".
There's a great solution in this post about how to achieve this, but my problem is that I also want to count the volume of responses for each category. This would mean I could make a line or bar chart to show how the proportion of complaints for each category has changed over time and the user could click on a cateogry to filter to the relevant id's in another visual.
I've added some sample data here.
Any help is much appreciated!
