Pivot Table
Overview
Pivot Table is an interactive table that quickly summarizes large amounts of data and extracts the required information. It can help you easily analyze and compare data to better understand it and make more informed decisions. It can perform aggregation operations on data within fields based on specific row and column grouping fields.
Settings
| Setting Item | Description |
|---|---|
| Data Source | Select the data source for the card. |
| Filter | Set the filtering conditions for data included in this card. |
| Data Volume | Set the quantity of data included in this card. |
| Sort Field | Set the sorting method for displayed data. |
| Row Grouping | Set the row grouping fields displayed in the pivot table. |
| Column Grouping | Set the column grouping fields displayed in the pivot table. |
| Calculation Method | Set the calculation method for data aggregation in the pivot table. Options: Count, Sum, Max, Min, Average |
| Precision | Set the precision for displaying aggregated data. |
| Dark Mode | Enable dark mode, the card can be used with a dark background. |
| Display Format | Set the data display format of the pivot table. Options: Table, Line Chart, Bar Chart |
| Enable Data Interaction | When users click on data, automation is triggered |
Display Formats: Line Chart and Bar Chart
| Setting Item | Description |
|---|---|
| Color | The color range items used when rendering the chart |
| Label Interval | Set the interval for axis divisions when rendering the chart |
| Label Angle | Set the rotation angle of scale labels when rendering the chart |
| Enable Data Zoom | Whether to enable image data zoom function. After enabling, freely focus on detailed data information, or overview the overall data, or remove the influence of outliers |
| Data Zoom Type | Data zoom method: Slider Data Zoom and Pan Row Data Zoom |
| Show Legend | Whether to display data legend |
| Legend Direction | The direction of legend display: Horizontal and Vertical |
| Horizontal Position | The horizontal position direction of legend display: Left, Center, Right |
| Vertical Position | The vertical position direction of legend display: Top, Center, Bottom |
Usage Scenarios
- Financial Analysis: Quickly summarize and compare revenue and expenditure data for different departments or products
- Sales Analysis: View sales performance across different products, regions, or time periods
- Market Research: Rapidly analyze survey data and identify key trends and patterns
- Inventory Management: Track inventory levels and identify products that need replenishment
- Human Resource Management: Analyze employee data such as salaries, performance, and turnover rates
- Project Management: Can be used to quickly summarize and analyze project data, helping to identify risks, track project progress, and measure project performance