Building Cross-Tab Reports

A cross-tab report is a table that shows the relationship between two or more variables and helps compare different things in your data. It's useful because it arranges information neatly so you can see how one thing relates to another. A common example is a grade book for a course, where each user's grades for various activities are listed. In such reports, the columns might differ from one course to another based on the activities involved in each course.

Cross-Tab Report example:

Open

To build a Cross-Tab Report:

1. In the Visual Builder, create a new dataset and select “Cross-Tab Table”

2. The Layout Menu looks different than a traditional table.

3. Add Vertical Columns first. You can add several vertical columns

4. Add Horizontal Columns.

5. Add Value Column to pick the desired datapoint for column values and any respective modifier.

For more resources on the whole Visual Builder process, visit Visual Builder Overview

Open

Vertical Columns: A section designated for static, unchanging columns in a report.

Horizontal Columns: An area where dynamic columns can be added to a report, allowing flexibility in content.

Values Columns: A segment where values corresponding to horizontal (dynamic) columns can be entered.

Horizontal Data Sorting: Enables selection of different data points for sorting horizontal columns.

Horizontal Data Limit: A space where a limit can be set for the number of horizontal (dynamic) columns displayed in a report.

Additional Visual Builder Articles:

Visual Builder Overview

Build a Multilevel Table Chart

Creating Component Filters for Dashboards

Creating Downloadable Certificates for Moodle

Exporting and Importing Dataset Definition

Adding Formulas to a Dataset to Create a Custom Datapoint or Column

Create Conditional Formatting to Highlight Important Data

SQL Building