How to Create and Use Pivot Tables in AIV Dashboards?

Pivot Tables in AIV are essential for summarizing large datasets. They allow users to group, filter, and analyze data organized into rows and columns, making it easier to identify trends and patterns.

Steps to Create and Use a Pivot Table in AIV:

1. Access the Dashboard: Log into AIV and navigate to your desired dashboard.
2. Add a Pivot Table Widget: Click on "Add Widget" and select "Pivot Table."
3. Configure Data Source: Choose the dataset you want to analyze.
4. Set Rows and Columns: Define the specific row and column fields for your pivot table.
5. Apply Aggregations: Set aggregation functions, such as sum or count, for your data.
6. Customize and Save: Adjust the formatting as needed and save your pivot table.
   
   For detailed guidance on creating Pivot Tables in AIV, please refer to the official documentation: AIV Pivot Table Documentation.