0
0
Google Sheetsspreadsheet~8 mins

Number formats (currency, percentage, date) in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Number formats (currency, percentage, date)
Dashboard Goal

Show sales data with clear number formats: currency for sales, percentage for growth, and date for order dates. This helps understand money, growth rates, and timing easily.

Sample Data
Order IDOrder DateSales AmountGrowth Rate
10012024-01-1515000.05
10022024-02-2023000.10
10032024-03-101800-0.02
10042024-04-0521000.07
10052024-05-1819500.03
Dashboard Components
  • KPI Card: Total Sales
    Formula: =SUM(C2:C6)
    Format: Currency (e.g., $)
  • KPI Card: Average Growth Rate
    Formula: =AVERAGE(D2:D6)
    Format: Percentage with 1 decimal place (e.g., 4.6%)
  • Table: Sales Details
    Columns: Order ID (plain), Order Date (formatted as Date, e.g., Jan 15, 2024), Sales Amount (Currency), Growth Rate (Percentage)
  • Line Chart: Sales Over Time
    X-axis: Order Date (Date format)
    Y-axis: Sales Amount (Currency format)
Dashboard Layout
+----------------------+-----------------------+
| Total Sales (Currency) | Average Growth (Percent) |
+----------------------+-----------------------+
|                                      Sales Details Table                                      |
+---------------------------------------------------------------------------------------------+
|                                      Sales Over Time Chart                                   |
+---------------------------------------------------------------------------------------------+
Interactivity

Add a date filter to select orders within a date range. When the date filter changes:

  • Total Sales updates to sum only filtered orders.
  • Average Growth Rate recalculates for filtered orders.
  • Sales Details Table shows only filtered rows.
  • Sales Over Time Chart redraws with filtered dates and sales.
Self Check

If you add a filter to show only orders after 2024-03-01, which components update and how?

  • Total Sales will sum sales from orders 1003, 1004, and 1005.
  • Average Growth Rate will average growth rates of these orders.
  • Sales Details Table will show only orders 1003, 1004, and 1005.
  • Sales Over Time Chart will plot sales for these filtered dates only.
Key Result
Dashboard showing sales data with currency, percentage, and date formats for clear financial and time insights.