0
0
Google Sheetsspreadsheet~8 mins

Filter views vs filters in Google Sheets - Dashboard Approaches Compared

Choose your learning style9 modes available
Dashboard Mode - Filter views vs filters
Goal: Understand the difference between Filter Views and Filters in Google Sheets

This dashboard helps you see how Filter Views and Filters work differently to sort and hide data without changing the original sheet for everyone.

Sample Data: Sales Records
Order IDRegionSalespersonProductSales Amount
1001EastAliceWidget250
1002WestBobGadget300
1003EastCharlieWidget150
1004SouthDianaGizmo400
1005WestEvaWidget350
1006EastFrankGadget200
Dashboard Components
  • KPI Card: Total Sales
    Formula: =SUM(E2:E7)
    Shows total sales amount from all orders.
  • Filter Component: Filter View for East Region
    Creates a filter view named "East Region View" that shows only rows where Region = "East".
    This filter view does not affect what others see.
  • Filter Component: Standard Filter for West Region
    Applies a standard filter on the Region column to show only "West" rows.
    This filter changes the sheet view for everyone.
  • Table: Filtered Data Using Filter View
    Shows data filtered by the East Region filter view.
    Users can switch to this view without changing the main sheet.
  • Table: Filtered Data Using Standard Filter
    Shows data filtered by the standard filter for West Region.
    This changes the sheet for all users until cleared.
Dashboard Layout
+----------------------+--------------------------+
|      Total Sales      |    Filter View: East     |
|      (KPI Card)       |    (Filtered Table)      |
+----------------------+--------------------------+
| Standard Filter: West | Standard Filter: West    |
| (Filter Control)      | (Filtered Table)         |
+----------------------+--------------------------+
Interactivity

The Filter View lets you create and save a filter that only you see. You can switch between views without changing the sheet for others.

The Standard Filter changes the sheet for everyone viewing it. When you apply or clear it, all users see the change.

Clicking on the Filter View or Standard Filter updates the respective filtered tables to show only the selected region's data.

Self Check

If you add a filter view for the South region, which components update?

  • The Filter View filtered table updates to show South region data.
  • The Standard Filter and its table remain unchanged.
  • The Total Sales KPI remains the same because it sums all data.
Key Result
Dashboard showing how Filter Views and Filters work differently to filter sales data by region in Google Sheets.