KPI widgets on dashboards can now work out their value from your data, so the number updates on its own when your sheet changes. When you add or edit a KPI, choose Calculated From Data in place of Custom Value, then pick a sheet, a column and a statistic.
changingKPICalculatedData
Statistics
KPIs use the same statistics as the column stats row. Number columns offer Sum, Average, Median, Minimum, Maximum and Standard Deviation. Date columns offer Earliest Date, Latest Date and the Date Range in days, months or years. Every column offers Count, Empty, Filled and Unique, plus their percentages.
Calculated KPIs also follow the slicers on the dashboard page, so the value changes as viewers filter the data.
Time periods
The Time Period tab limits the KPI to the rows whose date falls in a period. Pick a date column from the sheet, then choose a period such as Last 7 Days, Last 30 Days, Last 90 Days, Last 12 Months, This Week, This Month, This Quarter, This Year, Last Week, Last Month, Last Quarter or Last Year. Periods can end on the latest date in your data, which works well for imported files, or on today for sheets that get new rows.
Calculated trends
When a KPI has a time period, its trend can be calculated too. Under Compare To, choose Previous Period or Same Period Last Year. Averages, medians, minimums, maximums and percentages can also be compared with All Time.
The trend shows the percent change with an up or down arrow, and the trend label is written for you, though you can change it. Turn on Lower Is Better for costs, churn or wait times, so that a decrease shows in green.
Formatting
The Format tab sets how the value is written, with a number format or a custom format, significant digits, a prefix and suffix, and the number and currency locale. For example, 2,567,567 rounded to 2 significant digits shows as 2.6M.