New
Column Stats
A stats row now sits at the bottom of the data grid so you can see a summary of each column while you work with your data. Click the stat under any column to choose a different one. Your choices are saved with the chart.
Where to find it
The stats row appears on the Full Dataset and Plotted Data views of the sheet tab, and in the dashboard's Edit Sheet grid. On the Full Dataset view, the stats use your chart's filters, so the numbers match the rows you're charting. On the Plotted Data view, the stats are based on the values drawn in the chart.
Stats for number columns
Sum, Average, Median, Minimum, Maximum and Standard Deviation. Number columns show the Sum by default, and Year columns show the Count.
Stats for date columns
Earliest Date, Latest Date, and the Date Range in days, months or years.
Stats for every column
Count, Empty, Filled and Unique, plus Empty %, Filled % and Unique %. These help you find missing values or check how many different values a column holds before you chart it.