Dashboard Mode - Pie charts
Business Question
Which product category contributes the most to total sales in our store?
Which product category contributes the most to total sales in our store?
| Product Category | Sales |
|---|---|
| Electronics | 300 |
| Clothing | 200 |
| Home & Garden | 150 |
| Sports | 100 |
| Toys | 50 |
SUM([Sales]) = 800
+----------------------+----------------------+
| KPI Card | Pie Chart |
| Total Sales: 800 | Sales by Category |
| | |
+----------------------+----------------------+
| Data Table |
| Product Category | Sales |
+------------------+----------------------------+
A filter can be added to select specific product categories. When a category is selected, the pie chart and data table update to show only the selected categories. The total sales KPI card also updates to reflect the sum of sales for the filtered categories.
If you add a filter to show only Electronics and Clothing, which components update and what are their new values?