How to make data tables or crosstab in the Dashboard?

Modified on Wed, 29 Nov, 2023 at 6:01 PM

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)

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)

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, Favorite/Top Choice, and Overall Score
Other source questions that you can add in Stub Question	Analysis 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 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, Favorite/Top Choice
Other source questions that you can add in Header Question	Analysis Variable

3. 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.

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 select the Confidence Level you require for your analysis. To learn more about using the Significance testing, please refer to this article here.

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.

Was this article helpful?