Column data statistics can be used to find out basic statistical information about your column values without moving the data somewhere else like Excel. They are calculated for each column and are different for each column data type group: Numerical, Textual, Binary, Temporal, Other.
Immediate Column Data Statistics
Immediate Column Data Statistics were added in version 5.9 and contain a subset of the full column data statistical properties.
They are calculated live for the selected result grid while selecting cells.
Full Column Data Statistics
All columns include total, null, non-null and distinct row counts, top 40 most and least frequent values.
Numerical columns also include min, max, median, average and standard deviation of column values.
Textual columns also include min and max of column text values; min, max, median and average text lengths; min, max, median and average of word counts (split on whitespace only).
Binary columns also include min, max, median, and average of column data lengths, and min and max of column values.
Temporal columns also include min and max of column value.
Other columns also include min and max of column value.
All columns from each data type group mentioned above can be shown or hidden in the data statistics control for better visibility.
The UI uses visual cues to better represent statistical information like median, average or most/least frequent values.