New Column from Mapped Values -- Survey Monkey

juanfbages

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

kshah008

Hi all,

Can anybody help answer @juanfbages' question?

nalbright

Juan, is your format in Survey Monkey for the location information a fill in space or a drop down box?  I must admit I've never used the survey monkey format, as I tend to be more on the excel side of business myself.

juanfbages

It's a drop-down. What do you have in mind?

 

Juan

nalbright

What I was wondering is whether there was any chance that the results you got could be displayed on a table where the location information could be sorted more easily than the manual way you are now doing it.