I am working on some advanced reports using survey answers. I would like to aggregate scores based on the question code, but am having a hard time determining what each question code is.
I think I can use the Survey Question data space to find that. Is that the best way or is there something easier?
Thanks!
Question
What is the best way to view question codes for survey question?
Hi Ben,
I would recommend you leverage Survey Data Flattening as compared to Survey DataSpace if you are trying to create custom report on a survey. Survey Data flattening can be enabled by raising a support request and once enabled you can leverage it to flatten the entire survey data in MDA object.
For a flattened survey data, question name becomes column name and for matrix each of the sub-question also becomes column name.
I would recommend you leverage Survey Data Flattening as compared to Survey DataSpace if you are trying to create custom report on a survey. Survey Data flattening can be enabled by raising a support request and once enabled you can leverage it to flatten the entire survey data in MDA object.
For a flattened survey data, question name becomes column name and for matrix each of the sub-question also becomes column name.
I'll have to look into The Flattening as well. I had the same issue but where we had a survey which was duplicated monthly. This meant that the questions had the same text, but different question codes every month (each duplicated survey had unique codes). In order to aggregate over time, I filtered for the question text ("Question Name") I was reporting on, rather than the codes.
I also have used ad hoc reports showing Question Code with a filter for specific Question Names in order to see what the codes are.
[i]PS: Once I discovered the above hassles, I made some changes to our legacy survey process. We no longer make a new one monthly! ;)
I also have used ad hoc reports showing Question Code with a filter for specific Question Names in order to see what the codes are.
[i]PS: Once I discovered the above hassles, I made some changes to our legacy survey process. We no longer make a new one monthly! ;)
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.