Add a Pivot Table Widget

You can personalize and customize the pivot table appearance.

To add a pivot table widget

Step 1: On the Analytics homepage, click Manage Dashboards.

The Dashboards Groups page is displayed.

Step 2: Select a group to view its dashboards.

A dashboard list for the selected group is displayed.

Step 3: Select a dashboard (Grid view or List view) to which you need to add a pivot table.

The <DashboardName> page is displayed.

Step 4: In the upper-right corner, click the icon.

The Add Widget dialog box is displayed.

Step 5: In the Name box, type a name for the widget.

The widget name appears on the widget title bar.

Step 6: In the Description box, type a brief description of the widget.

Step 7: In the Widget Type list, select Pivot Table.

Step 8: In the box, search for a report, and then select a report.

All reports in your organization or its descendants appear in the box. Parent organization filters appear for subgroup as well. In a widget you can select reports that are public or the reports that you have authored.

A warning sign next to the report title indicates that the report contains organization filters that do not allow dashboard access. The data for those organizations are not displayed on the dashboard.

Step 9: Click Add Dataset.

In a pivot table, you can have only one dataset per widget.

Step 10: Click the icon if you need to remove the dataset.

Step 11: In the Column section, select the X-axis and Y-axis for the pivot table.

You must select at least one X-axis. If there is no Y-axis available or you do not select a Y-axis, by default the pivot table displays the count of grouped X-axis values.

Step 12: Click the icon to display the data in a horizontal line as a table row. Click the icon to display the data in a vertical line to make it the pivot column.

Step 13: Click Save.

The pivot table widget is saved and appears on your dashboard.

© NexPort Solutions. All Rights Reserved.

Last updated