Understanding the Structure of Reports

A Report is an Element that you can use to visualize any arbitrary data set.  Unlike a Metric, a report is not limited to displaying information over time.

A report is made up of the following building blocks:

  1. The data set to be visualized.  This is the Report's Result Set returned by a fetch command; e.g., using a SQL Statement, Plug-in Command, or a manually uploaded file
  2. One or more Pivots tables built using columns selected from the Result Set
  3. One or more Charts constructed using the Result Set or the data included in a Pivot table

Report Structure Diagram for Complex Report with Multiple Pivots and Charts

Report Structure Diagram for Complex Report with Multiple Pivots and Charts

When should I create a PIvot Table in a Report

When should I create a PIvot Table in a Report

Define a Pivot Table when you want to display and/or visualize selected Result Set columns if you need to sort,  count, or sum one column and show the results using a cross-tabular display. The resulting Pivot Table can be shown in the report as well as used as the basis for an associated Chart.  The example below shows a typical Pivot Table used to create a cross-tab in which a measure in the Result Set is aggregated across a set of columns.

How do I Edit the Pivots and Charts in a Report?

  1. Pivots, Charts and External Visualizations each have their own editors that are accessible from the Report Content tab.
  2. A tutorial is also provided explaining Dynamic Pivots.

For details, see: