Pivot Table

    A Pivot Table is a versatile table that allows for dynamic rearrangement of data, facilitating multi-dimensional analysis.

Navigation to Create/Edit a Pivot Table Chart:

1. Access the Dashboard:
   • Navigate to the dashboard where you intend to add or edit a metric card.
2. Create or Edit a Metric Card:
   • For a new chart, click on "Create Metric" in the desired dashboard.
   • To edit an existing chart, open the metric card you wish to modify.
3. Choose Chart Type:
   • In the metric editing interface, locate the "Chart Type" selector.
   • Select "Pivot Table" from the available chart types.

Creating a Custom Pivot Table:

You have the flexibility to create a Pivot Table tailored to your specific data analysis requirements. The Pivot Table in DataBrain allows you to:

• Arrange and reorganize data dynamically for comprehensive and multi-dimensional analysis.
• Drill down into data categories and metrics for detailed insights.
• Customize the table layout, including rows, columns, and values, to best fit your data visualization needs.
• Apply various aggregations and calculations to summarize data effectively.

In addition to these appearance options, you can also set up actions for the chart under the "Actions" tab. For more detailed information on setting up chart actions, please refer to this documentation.

The Pivot Table's ability to adapt to various data explorations makes it a powerful tool for gaining insights from complex datasets.