Include and exclude
In Netigate it is very easy to display and view the result for specific groups of respondents to view just their result, it could for example be the result for one specific department in an employee survey, a type of customer in a CSAT survey or perhaps a specific group of people in a market research survey.
Includes and excludes can be done in several steps och in combination with each other. What we do when we choose to include something is that the result in the entire survey will only be displayed for the respondents that picked the option we choose to include for example all respondentes above the age of 50 in the question asking them about their age or perhaps everyone living in Londons in our market research survey. If we exclude something however the result will then hide/remove those respondents from the total result for example to remove the answers from everyone living in London.
To create a filter like this (either include or exclude) is very easy and can be done with any type of question (You can even include a specific word that has been written in a open question but more on that later). Locate the question you want to work with in the result of your survey, in this case let’s say it’s question 2 where the respondent answered who their account manager is. So let’s take a look at the result for all our customers that have Isabella as a account manager, click on the amount of answers in the tabel just next to the graph as the image below shows. Now a plus and minus sign will be shown, click the plus sign and then OK. The result will now be reloaded and only show the answers from the respondents that said that they have Isabella as an account manager throughout the entire survey. If we want to look at all the answers from everyone that do not have Isabella as an account manager we would have had to click the minus sign instead and then OK.
After we’ve done a filter like this and view and/or downloaded the result we can easily reset it by click the reset button in the upper left corner.
If we want to include a specific word instead as I mentiond above we have to first of all locate our open text question, a word cloud is displayed as normal and we’ll be able to see all the words that have been entered in to the question by all the respondents. So in the example I’m going to use we will include the answers from all the respondents that typed the word “Quality”. So we click the word a menu is now displayed and from here we simply click include in report. The result for the entire survey and all questions will now be reloaded and only display the answers from the respondents (21 respondents) that typed the word Quality in this open question.
When you’ve set your filters (being includes or excludes) you can easily view what you’ve done by clicking the filter button in the menu at the top.
The breakdown feature can be used to compare the result between the different options in a question, for example to find differences in perception between genders, age or maybe departments within a company.
In this example we used the breakdown method on a questions regarding gender. So in this case we click on the highlighted text in the image to compare the result between the men and women throughout the entire survey. On each question you’ll now only see how the Man answered vs Women and not the surveys total result.
As the image below no illustrates we can see the difference in years of employment for the men and the women.
Add series is a powerful tool to break down the result into different levels and sub levels. You can then decide to save it in to different series to make them comparable with each other.
When do I use add series
Add series is to be used when you need specific data to be displayed. For an example, you have now made a VoE survey and wish to see the responses for the sales department vs the IT department.
How do I use add series?
First you need to do is to open the result of the survey, this you do by clicking on the survey name.
In this case we will do comparison on gender then we go deeper and chose departments.
First we will create a comparison on gender and split them up in to two different series.
We start with the Men.
1. Click on the number of answers, in this case we have 64 and comparison options will now appear.
2. Click on the “plus” symbol then “OK”
3. Go to the top of the page and click “ADD SERIES”
4. You can now see how a series has created for you called “Man”.
You can of course edit the name of the series the way you like, just hoover the mouse over “Man” and you see.
Now just click on the pen and you can now change the name to a desired name. If you wish to remove this series just click on the trash can symbol (you can never delete the entire result so don’t worry).
5. In this step we will now add “Women” to “Series 2”. To do this click on the number of respondents which in this case is 56, once again the cross tabulation option will appear, simply just click the “plus symbol” and then “OK”. The series 2 will now automatically change name to “Women”
This is how it looks like now
Note: The highlighted numbers in green represents WHAT you have chosen to set your cross tabulation on.
This concludes the first step of the cross tabulation, the survey has now been split up in to two series, Men and Women. Our next step is to break down this even further, in this case on departments. To do this we have to repeat the similar way we added “Man” and “Women”. That means two steps. First we need to add department to Man and to Woman
First click on the number of respondents for the department in question. In this case we can chose sales. Simply click on the number of respondents in the “Man” column which is 25 and again the cross tabulation options will appear. Click on the “plus sign” and finish with “OK”. Repeat this step for “Woman” but of course you should now chose the sales number located in the same column as “Woman” which is 26.
It should now look like this. We have now added Sales department to each gender.
If you now scroll through the survey the result will only show the answers for Men and Women working for the sales department.
You can of course cross tabulate even further if you so wish, set up departments’ vs each other and so on the only limit is the questions you’ve asked your respondents.
How do I remove my cross tabulation?
How do I remove my cross tabulation?
First is simply just to press “RESET” in the upper left corner, and then “YES” to confirm. What this does it will remove all the cross tabulation, filtering that has been made and return to the original result. Second option to remove a cross tabulation. Simply click on “FILTERS” located in the upper main menu, it will also be colored green.
To remove the cross tabulations, click on the white “X” and it will be removed, confirm your changes by clicking “OK”.