Data Explorer

Updated May 22, 2023 18:27

Expand-All Collapse-All

Data Explorer is a feature that enhances the functionality of the Reports by incorporating pivot tables. Pivot tables are a powerful analytical tool that summarizes and reorganizes data, providing insights into underlying patterns.

Data Explorer uses a query to pull the relevant data for analysis. This query could be customized to fetch specific data sets from a database or other data sources. Once the data is retrieved, you can apply pivot tables to the obtained dataset.

Pivot tables enable you to aggregate and summarize data based on different dimensions and metrics. They provide a flexible way to organize and analyze data by allowing users to drag and drop data fields into different sections of the pivot table interface. These sections typically include rows, columns, values, and filters.

Create the Report

To add a Data Explorer table to a report:

From the main navigation, select Queries / Reports.
At the top right, select the Report icon.
Select New Report, enter a name, and optionally select a Realm and Folder, then click Save. Or choose an existing report.
From the right, select Data Explorer. An Edit Part pop-up appears.

In the pop-up, enter the following:
- Name: Enter a name for the part.
- Type: Configurable Joins
- Category, Base: Select a base that narrows your results as much as possible. For example, if you want person information, select the Person base.
Click Save. A query configuration pop-up appears.

Example configuration used in this article.

Add exports to the query. These exports represent the data available for the pivot table. Determine the population available to the pivot table with filters. This section can be accessed and updated anytime by selecting the Edit button in the upper right corner.
Click Save.

Important!

One or more filters must be applied to the query to ensure the Data Explorer's fast, reliable operation.

Create the Explorer

Explorer Widget

To create a pivot table, select the Explorer widget. Provide a Title for the pivot table, and select the user edit options. There are three user edit options for when the portal renders, Editable, Persist Edits, and choosing neither.

- Editable - Let users edit the pivot table as they view it, though changes are reverted when the page is refreshed.
- Persist Edits - Users can make edits to the table, and those changes will save even when the page is refreshed. Requires Editable be selected.
- With neither option selected - Users who have access to the report can view the pivot table but cannot interact with it.

Explorer Widget Layout

The Explorer widget appears, comprised of the four main areas of a pivot table:

Values Area - Where data is displayed.
Row Area - Left of the Values Area, where exports can be placed to create a row-oriented perspective.
Column Area - Across the top of the Values Area, exports placed here will provide a column-oriented perspective, helpful in creating a matrix or showing trends over time.
Filter Area - Configure and filter which data display on the pivot table.

Selecting Data to Display

Additionally, on the far left of the Explorer widget, you'll find a list of exports available for the pivot table, as generated by the query setup earlier.

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 the export and deselecting the value in the list. Use Select All or Select None to activate or deactivate all exports at once.

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 you include on the table. The Charts tab includes additional chart types. Lastly, the Customize tab allows further customization of a selected chart.

Static Content

The Static Content widget is an HTML WYSIWYG. Dragging the widget over to the report section will open the HTML WYSIWYG, and HTML support content can be added to the report.