Cross Table Tool
-
Cross Table Overview
Use the Cross Table tool to analyze relationships in data and understand interactions between variables. The Cross Table report can be used to quickly add mu...
-
Adding a Cross Table Tool
Use Cross Table to analyze relationships in data and understand interactions between variables. You can use the Cross Table report to quickly add multiple qu...
-
Crosstable-Settings and Setup
1: Set Up Access and Display OptionsBy default, all content—questions, calculation types, filters, and settings—is turned on in the Cross Table Tool. Admins ...
-
Managing Favorites in the Cross Table tool
In the Favorites tab of the Cross Table tool, you can save all your favorite tables after selecting variables and calculations. This will save time in o...
-
Cross Table Calculations
OverviewUse the Calculations tab to apply different calculation types based on the question types you've selected. You'll only see options relevant to your c...
-
How to Add Filters to a Crosstab?
CrossTab filtersA CrossTab report allows you to quickly add filters and apply hierarchical filters to your variable selection. In this chapter we will explor...
-
How to Limit Content?
All questions, calculation types, settings, etc. are turned on by default. Using Setup options, Admins can limit content which user will have access to. To s...
-
How to Add Ranking to a Cross Table?
The ranking calculation is also available in the Cross Table tool. The rank can be based on any calculation type like mean values, percentage shares, count e...
-
How to Hide Question Texts in Nested Tables?
An option for hiding the question texts in tables have been added which makes tables with many nesting levels easier to read as shown in the example below. H...
-
How to Show the Effective Base Size in a Table?
When working with weighted data the effective base size can now be displayed in the tables in the same way as the weighted and unweighted base size can be di...
-
Is Moving Average Supported in the Cross Table Tool?
Yes, Forsta Visualizations CrossTabs supports moving averages up to 53 periods. Select the interval as a split, so you will have the options to select the in...
-
What Is the Format of the Cells in Excel of the Exported Crosstabs?
The values in the tables are formatted as numbers instead of text in the Excel export. The logic is applied by default so the user does not need to select fo...
-
How Can Report Users Use the Cross Table Tool?
Attached are user guides for report users.Cross table User Manual 20190905Cross table User Manual 20210921
-
How Can Hierarchical Filters Be Viewed?
You can search in the Hierarchical filter tree which makes it easy to find nodes.Here we see the new search function at the top of the panel, in the left ima...
-
How Can We Use Templates in the Cross Table Tool?
1: Using Templates in the Cross Table ToolTemplates help users create tables more quickly by applying predefined settings for splits, filters, and layout. Wh...
-
How to Sort by Question/Answer in the Cross Table?
In the Cross Table tool you could previously sort a table by value by clicking any of the “split” column headers, now it is also supported to sort by any Que...
-
How to Add, Delete and Reorganize Your Sheets in Crosstabs?
Add new sheetA new sheet is inserted by clicking any of the options highlighted in the image below. The new sheet is inserted after the current selected shee...
-
What Is the Presentation Mode for Crosstables?
A Presentation mode is available, in this mode the tables area is shown only, the table settings area is hidden and the Workbook and sheet panel is minimize...
-
Workbooks Overview (Cross Table tool)
The Workbooks and Sheets feature in the Cross Table tool is similar to the Decks and Slides feature in StoryCreator. The Workbooks and Sheets feature allows ...
-
How Does Forsta Visualizations Manage Limited Data Access Based on Normal Filters?
Access to regular filters are now supported in the Cross Table tool which allows you to limit what data the users can use when creating tables. Access to Hie...
-
Cross Table: The Generate Table Toolbar
The toolbar on the Generate table tab contains commonly used table settings. To see all available settings, see the Calculations tab. 1: Calculat...
-
Table key - CrossTable tool
Table KeyThe information displayed in the table summary information: “the table key” is now customizable.It is possible to choose among a set of items to be ...
-
Clipboard - CrossTable tool
ClipboardClipboard concept has been introduced to support copying sheets between workbooks. You can for example load a shared workbook, add the interesting s...
-
Using Filters in CrossTab
You can apply filters to a CrossTab report to focus your analysis on specific time periods or variable groups. This guide shows you how to use filters, inclu...