Data Explorer expands the capabilities of the Reports tool to include pivot tables. Using data pulled from a query, pivot tables can summarize and reorganize that data and reveal underlying patterns.
Data Explorer Table
To add a Data Explorer table to a report:
|
|
|
|
|
Example configuration used in this article. |
|
Example exports, filters, and joins used in this article. |
Important!
One or more filters must be applied to the query to ensure the Data Explorer's fast, reliable operation.
The resulting (temporarily) blank page will include two available widget options available on the right:
|
Explorer
Create the Explorer Widget
To create a pivot table, select the Explorer widget. An Edit Part pop-up appears. Provide a Title for the pivot table, and select the edit options. There are three edit options the rendered portal: Editable, Persist Edits, and choosing neither.
|
Click Save.
The Explorer Widget Layout
The Explorer widget appears, including the four main areas of a pivot table:
|
Selecting Data to Display
Additionally, a list of exports available for the pivot table appears on the far left of the Explorer widget. This list appears as generated by the previous query setup. Drag these exports to the Row or Column Areas to incorporate them into the data display. |
Exclude the returned value of an export by selecting or clearing the export value in the list. Use Select All or Select None to activate or deactivate all exports simultaneously. |
When a chart is selected for a data display type, double-clicking the chart presents additional options: Start, Charts, and Customize. |
The Start tab provides recommended chart types according to the data included in the table. The Charts tab includes additional chart types. Lastly, the Customize tab enables further customization of a selected chart. |
Static Content
The Static Content widget is an HTML WYSIWYG editor. Dragging the widget to the report section opens the editor, and HTML support content can be added to the report.