How to make data tables or crosstab in the Dashboard?

How to make data tables or crosstab in the Dashboard?

What is a CrossTab?

The Crosstab feature is a useful analysis tool commonly used to compare the results for one or more questions/variables with the results of another question/variable. 

Crosstabs (cross-tabulation) are basically data tables that allow you to present results in different subgroups and examine relationships within the data that might not be obvious when simply looking at the total sample. 

By using crosstabs, you can divide large data sets into subgroups and make quick comparisons between them which will help you analyze your survey results. 

How to set it up?

1. In the CrossTab Page, select your Stub Question(s) and Header Question(s) on the drop down list. 

New update: Apart from selecting the question on the drop down list, users can also type and search questions on the Stub and Header Question.



Stub Question (side variable)

- You can select as many questions as you want depending on which data/results you want to read or analyze (For example -- Choice of Cellphone brand, Financial Situation). 


New update: The Stub Question supports up to 100 line on one page (other tables will show on the succeeding page)



Current question types that you can add in Stub Question
Single Choice, Multiple Choice, Rating, Rank Order, Scale, Map, Numeric, Popup Cards, Tradeoff Ranking, NPS Plus, Virtual Question, OE question (after codes exported from AI Coding) 
  • For Rank Order - You can add questions by Rank (example: Rank 1, Rank 2, Rank 3) and by Total Selection
  • For Tradeoff Ranking - You can add questions by Likes, Dislikes, Favourite/Top Choice, and Overall Score
Other source questions that you can add in Stub QuestionAnalysis Variable


Header Question (top variable or banner) 

- You can select as many questions as you want depending on the subgroups you want to read or analyze (For example -- by Country and by Age).  



Current question types that you can add in the Header Question
Single Choice, Multiple Choice, Rating, Rank Order, Scale, Map, Popup Cards, Tradeoff Ranking, NPS Plus, Virtual Question, OE question (after codes exported from AI Coding) 
  • For Rank Order - You can add questions by Rank (example: Rank 1, Rank 2, Rank 3) and by Total Selection
  • For Tradeoff Ranking - You can only add questions by Likes, Dislikes, Favourite/Top Choice
Other source questions that you can add in the Header QuestionAnalysis Variable


2. After choosing your questions/variables, the system will automatically show you the generated table or crosstabs. To better view the results you can download the tables in an Excel format by clicking the export button on the top right icon.


3. You can also check if the results have significant differences when you compare them against the Total Sample by toggling the Highlight Significant Difference and selecting the Confidence Level you require for your analysis. To learn more about using the Significance testing, please refer to this article here. 



4. If the existing questions are not sufficient to analyze the data sets you require, you can create a new variable and use it for your crosstabs. To learn more about making new variables, please refer to the article here. 

Please note: The Dashboard currently allows only one level of header or stub. So if we add multiple questions or variables to the header/stub, the variables will be independent.

For example, if we add concept and gender to the header, the tables will show by concept, and by gender separately. The results/analysis will not be combined for concept AND gender. 

If users want to run the analysis by concept AND gender, they need to put concept as a filter and run the analysis by gender for each concept one by one.


Other features:

Show count - When enabled, the data tables will display the actual count instead of the percentage scores

Multi Select - When enabled, users can multi-select a range of questions first, and then load the crosstab in one waiting period. With this feature, users can run and export a longer set of data tables in one waiting period. 
​
How Multi Select works:
1. Toggle on Multi Select first
2. Add all your Stub and Header questions
3. Click Fetch data (Note: Loading period still varies depending on your sample size)


    • Related Articles

    • How to filter data in the Dashboard?

      In the Dashboard, FILTERS are useful analysis tool that allows you to filter the responses from the total sample and show only the data for a certain group/segment or data set that you have selected. How to set it up? 1. You can use the Filter ...

    • How to make summaries from different segments in the Dashboard?

      What is Smart Summary? The Smart Summary feature similarly works like a Crosstab but for Open End questions. Smart Summaries are AI generated summaries that allow you to view verbatim summaries based on the total sample (Total), side-by-side with the ...

    • AI Coding on the Dashboard - Overview

      What is inca AI Coding? In this tool, you can add/remove/edit/merge the codes generated by the AI model for your open-ended verbatim. For the coded data, users can either export them to SPSS or CSV data file and run tables in their preferred ...

    • How the data is analyzed and visualized for Tradeoff Ranking?

      How Tradeoff Ranking works? Tradeoff Ranking is mainly used to test the attractiveness and competitiveness of different ideas, including concepts, messages, logos, features and other stimulus materials. It explores further why the customers like or ...

    • How to understand the Significant Differences on the Crosstab Page?

      Interpretation of Significant Differences Let’s use the following example to illustrate how to interpret the significant differences on the Crosstab page. In the following case, we want to compare people's favourite sportswear brands across different ...