Dashboard Crosstab Widget

What is it?

• The Crosstab widget can display a base KPI and its results distributed in a cross table view (Rows and Columns).
  • User experience against client and server zone
  • Delay distributed between source and target cities
• Crosstab widgets can color code the cell based on threshold
• Crosstab widgets use a TopN to limit size of table
• Crosstab widgets support Row/Columns that are
  • Matched – Column values are matched to row values
  • Independent – Column values are independent from row values
  • Filtered – Columns are filtered by row value

Example

City to City, Client to Server, and Server to Application

Runtime Options

• Click on a cell to expand to TopN
• Hover on a cell for full resolution
• Export to CSV

Authoring Options

Adding a Bin

Capabilities

• Use multiple Crosstab widgets to show groups of TopN.
• Try to restrict the size of the TopN if you have many Crosstabs.
• Supports 5, 25, and 100 columns and rows to limit the table size.
• Crosstab boxes can link to other dashboards and support filters on TopN.
• Colors can help in identifying where to look. Rows or columns of red indicate correlation. No Bins no color
• Rows and columns can be independent, matched, or filtered by.

Options

Row/Column Values

Use bidirectional location data

Enable the Use bidirectional location data toggle to view both SD and DS data in the same crosstab.

When enabled, the corresponding DS or SD metric column is added for every column categorization. Additionally, the row and column Group by are set to use the aliased source and destination location metadata.