A Pivot Table is a visualization widget that allows you to analyze and summarize large datasets by organizing and grouping data based on multiple dimensions and attribute levels. Users can interact with the Pivot Table widget to explore the data further, drill down into subcategories, and adjust the table layout to focus on the most relevant data.

One of the key benefits of the Pivot Table widget is its flexibility, which allows you to quickly adjust the dimensions and attributes you are using to analyze your data. This makes it easy to identify trends and insights that need to be apparent when viewing the data in its raw form.

To create a Pivot Table Widget

The Pivot Table widget can be plotted in any custom Reporting dashboard, depending on permissions. To get started, you can use any existing editable dashboard or create a new one. Refer to this article to learn how to set up a Custom Dashboard.

Once you have the dashboard where you want to add the visualization widget, follow the steps below –

1. On the custom dashboard, click Add Widget in the top right corner.

   

2. On the widget builder, enter the widget's name, and select Listening as Data Source.

3. Select Pivot Table as a visualization type for your Listening widget.

   

4. Under the “What would you like to plot on your widget?” section, ou will be given the below fields:

   • Levels: You can choose any desired dimensions to plot on different levels. Levels will be shown in a nested format which you can see by drilling down on the foremost level. E.g., the Country is plotted in Level 1 and the Sentiment in Level 2, which can be seen by drilling down on each country.

   • Columns: Choose the metrics you want to see against your desired dimensions, e.g., Mentions.

     

   • You can also choose more than one dimension to plot on the same Level to see them in a side-by-side view in the Pivot table.

5. Select the configuration options as desired. For more information, refer to the ‘Configuration options’ section below.

6. Under the "Defined Advanced Options" section, you can apply filters, define additional properties and set personalized targets with these options.

7. Click Add to Dashboard on the bottom right corner to create your new widget.

Confuguration options

The configuration options available for the Table widget will work as follows –