MIN and MAX functions in Google Sheets - Dashboard Guide

Dashboard Mode - MIN and MAX functions

Goal

Find the smallest and largest sales amounts from a list of sales data to understand the range of sales performance.

Sample Data

Salesperson	Sales Amount
Alice	250
Bob	400
Charlie	150
Diana	300
Eva	500

Dashboard Components

• Minimum Sales: A KPI card showing the smallest sales amount.
  Formula: =MIN(B2:B6)
  Result: 150
• Maximum Sales: A KPI card showing the largest sales amount.
  Formula: =MAX(B2:B6)
  Result: 500
• Sales Data Table: Shows all salespersons and their sales amounts for reference.

Dashboard Layout

+----------------+----------------+
| Minimum Sales  | Maximum Sales  |
|     150        |      500       |
+----------------+----------------+
|        Sales Data Table          |
|  Salesperson  |  Sales Amount    |
|  Alice       |  250             |
|  Bob         |  400             |
|  Charlie     |  150             |
|  Diana       |  300             |
|  Eva         |  500             |
+---------------------------------+

Interactivity

Add a filter to select specific salespersons. When you choose a salesperson, the Minimum Sales and Maximum Sales cards update to show the smallest and largest sales amounts only for the selected salesperson(s). The Sales Data Table also updates to show only the filtered rows.

Self Check

If you add a filter to show only salespersons with sales above 300, which components update and what are their new values?

• Minimum Sales card updates to 400 (Bob's sales).
• Maximum Sales card updates to 500 (Eva's sales).
• Sales Data Table shows only Bob and Eva rows.

Key Result

Dashboard shows the smallest and largest sales amounts from a sales list with filterable salespersons.