Cross Table

The Crosstable view in Mapp Intelligence allows you to analyze the relationships between two dimensions simultaneously, providing a detailed breakdown of data. While it is more limited compared to the Multi-dimensional analysis (Pivot Table), the Crosstable excels in visualizing changes through its heatmap chart, making it easier to identify trends and patterns.

Key Features

1. Two-Dimensional Analysis: Analyze exactly two dimensions side-by-side to uncover relationships and trends.

   Example: Weekdays by Hours to identify patterns in user behavior, such as peak activity times or low-traffic hours.

2. Flexible Metric Selection: Choose a single metric to analyze, such as:

   • Visits

   • Qty Orders

   • Bounce Rate

3. Filtering Options: Apply filters to narrow down your analysis to specific elements (e.g., focus on specific weekdays or hours with the highest traffic).

4. Chart Visualization: The Crosstable offers a heatmap visualization that highlights changes in the selected metric.

   • High-intensity periods (e.g., hours with high visits) are shown in red or darker colors, while low-intensity periods are shown in lighter colors.

5. Configurable Display Options: Adjust the number of elements displayed for each dimension to suit your analysis needs.

Example: Using Crosstable in Weekdays Analysis

To demonstrate how to use the Crosstable view, let’s take a practical example using the Weekdays Analysis.

Scenario: You want to analyze how visits vary by hour for each weekday, helping you identify peak activity times for your website.

Step-by-Step Instructions

1. Open the Weekdays Analysis (Visitors > Time > Weekdays)

2. Activate the Crosstable View: Click on the Crosstable icon in the top menu to change the view.

3. Select the Second Dimension: In the Crosstable settings, choose Hours as the second dimension to cross-analyze with weekdays.

4. Choose a Metric: Select Visits as the single metric to display in the Crosstable.

5. Review the Heatmap Visualization: The Crosstable heatmap is arranged with a color gradient:

   • Blue indicates low values (e.g., fewer visits during a given hour).

   • Red indicates high values (e.g., peak traffic hours).

   Use mouseover to see the exact value for each cell in the heatmap, providing precise insights into traffic patterns.