Hello Looker & Community,
Part of my Web app collects survey data. Prior to using looker, my users were accustomed to pulling survey data in a particular format, which they would distribute to our customers.
Ideally, my customers would like to see survey data in a format where each line is a form submission as shown in the second picture below. Unfortunately, since the survey answers field is a string, rather than some sort of numeric, I can’t pivot over questions.
Is there any way to get this pivot with dimensions acting as measures for this to work in looker without monkeying around with a complex postgres query?