UNIQUE function in Google Sheets - Dashboard Guide

Dashboard Mode - UNIQUE function

Goal

Find all unique product names sold from a list with duplicates.

Sample Data

Order ID	Product	Quantity
1001	Apple	5
1002	Banana	3
1003	Apple	2
1004	Orange	4
1005	Banana	1
1006	Grapes	6
1007	Orange	2

Dashboard Components

• Unique Products List: Shows all unique product names from the Product column.
  Formula: =UNIQUE(B2:B8)
  Output:
  

  Apple

  Banana

  Orange

  Grapes

• Total Orders: Counts total number of orders.
  Formula: =COUNTA(A2:A8)
  Output: 7
• Total Quantity Sold: Sums all quantities sold.
  Formula: =SUM(C2:C8)
  Output: 23

Dashboard Layout

+----------------------+------------------+
| Unique Products List  | Total Orders     |
| (UNIQUE formula)      | (COUNTA formula) |
+----------------------+------------------+
| Total Quantity Sold                      |
| (SUM formula)                          |
+---------------------------------------+

Interactivity

Adding a filter on the Product column will update the Unique Products List to show only unique products in the filtered data. Total Orders and Total Quantity Sold will also update to reflect filtered rows.

Self Check

If you add a filter to show only orders with Quantity > 3, which components update and what are their new values?

• Unique Products List: Apple, Orange, Grapes
• Total Orders: 3
• Total Quantity Sold: 15

Key Result

Dashboard shows unique products sold, total orders, and total quantity from sales data.