LinkedIn
Twitter
Hi there! 👋
Context: I'm running feature preference survey and I want to create a dashboard on Looker so I can share with the entire company.
Problem: One of the fields is set to multiple choice and as result, when a person selects more than one option, they are represented on the same row in Google Sheets, separated only by comma.
Ex: What are your favorite features?
Answer 1: dashboards
Answer 2: dashboards, integrations
Answer 3: integrations, pivot table, dashboards
Answer 4: pivot table, integrations, dashboards, timeline
Im trying to create a chart that represents how many times a feature was mentioned, but my difficulty is that the charts are looking like image 1, instead of image 2
(Image 1)
(Image 2)
What is the best way to count how many times a feature was mentioned and create specific metrics and dimensions for that?
Disclaimer: I dont have much experience with advanced filters and regex, but I can try!
