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:
- 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
- One or more Pivots tables built using columns selected from the Result Set
- 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
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?
Creating Reports has been greatly simplified by using the new Dataset Reporting feature - see Dataset Reports Overview (New in 5.3)