Statistical summary card in Tableau - Dashboard Guide

Dashboard Mode - Statistical summary card

Business Question

How can we quickly understand the sales performance and variability for our products in the first quarter?

Sample Data

Product	Sales
Alpha	120
Beta	150
Gamma	100
Delta	130
Epsilon	110

Dashboard Components

• Total Sales Card: Shows total sales across all products.
  Formula: SUM([Sales])
  Result: 610
• Average Sales Card: Shows average sales per product.
  Formula: AVG([Sales])
  Result: 122
• Minimum Sales Card: Shows the lowest sales value.
  Formula: MIN([Sales])
  Result: 100
• Maximum Sales Card: Shows the highest sales value.
  Formula: MAX([Sales])
  Result: 150
• Standard Deviation Card: Shows how much sales vary.
  Formula: STDEV([Sales])
  Result: Approximately 19.24
• Sales Bar Chart: Visualizes sales by product.
  X-axis: Product
  Y-axis: Sales
• Sales Data Table: Lists products and their sales values.

Dashboard Layout

+--------------------------------------------------+
| Total Sales | Average Sales | Min Sales | Max Sales |
|    (610)    |     (122)     |   (100)   |   (150)   |
+--------------------------------------------------+
| Standard Deviation (19.24)                        |
+--------------------------------------------------+
| Sales Bar Chart                                  |
|  (Products on X-axis, Sales on Y-axis)          |
+--------------------------------------------------+
| Sales Data Table                                 |
|  (Product and Sales columns)                     |
+--------------------------------------------------+
    

Interactivity

A filter for Product allows selecting one or more products.

When a product filter is applied:

• All summary cards (Total, Average, Min, Max, Std Dev) update to reflect only selected products.
• The Sales Bar Chart updates to show bars only for selected products.
• The Sales Data Table shows only the filtered products.

Self Check

If you add a filter to select only products with sales greater than 120, which components update?

• All summary cards update to show totals, averages, min, max, and standard deviation for filtered products.
• The Sales Bar Chart updates to show only bars for products with sales > 120.
• The Sales Data Table shows only those filtered products.

Key Result

A dashboard showing total, average, min, max, and standard deviation sales with a bar chart and data table for product sales.