Hello,
We are working with survey data using the Survey Monkey connector. From the seven questions in the survey, we are interested in looking at the "Additional Comments" question by "Location". Unfortunately, the "Location" information is obtained through a question. This means that our data looks like this:
| Respondent ID | Question | Response |
| 1 | 1. What is your location? | New York |
| 1 | 7. Do You have additional Comments? | The service was great |
| 2 | 1. What is your location? | Washington |
| 2 | 7. Do You have additional Comments? | The staff was great |
| 3 | 1. What is your location? | Philadelphia |
| 3 | 7. Do You have additional Comments? | |
| 4 | 1. What is your location? | New York |
| 4 | 7. Do You have additional Comments? | I had a good experience |
We would like to create a card with a table where the comments can be filtered by location. (See below)
| Location | Additional Comments |
| New York | The service was great |
| Washington | The staff was great |
| Philadelphia | |
| New York | I had a good experience |
So far we have not been successful at creating this table using the regular card building tools. Our quick solution was to create a mapping Respondent_ID/Location table using Domo cards, exporting the table into an excel file, uploading it as a data source, and combining this table with the original survey results using data fusion, which yields a table like this:
| Respondent ID | Question | Response | Respondent ID_2 | Location_2 |
| 1 | 1. What is your location? | New York | 1 | New York |
| 1 | 7. Do You have additional Comments? | The service was great | 1 | New York |
| 2 | 1. What is your location? | Washington | 2 | Washington |
| 2 | 7. Do You have additional Comments? | The staff was great | 2 | Washington |
| 3 | 1. What is your location? | Philadelphia | 3 | Philadelphia |
| 3 | 7. Do You have additional Comments? | | 3 | Philadelphia |
| 4 | 1. What is your location? | New York | 4 | New York |
| 4 | 7. Do You have additional Comments? | I had a good experience | 4 | New York |
While this works, the process is extremely manual and we are looking for something more streamlined. Is there an easier/more automatic way of doing this? Would it be possible to create a data flow for the ID/Mapping table and link it so that it updates the data fused table every time the survey is updated?
Thanks for any insights.
Juan
