View column details
You can view column details for all column types except JSON. Column details provide automatically generated data distribution statistics, allowing you to assess the shape and quality of your data.
This document covers how to access column data, and explains the fields that are provided within the column details overview.
User requirements
- You must have Can view access to a document to see column details.
Access individual column details
To see details and statistics about an individual column:
- Click the down arrow (
) to open the column’s dropdown menu. - Select Column details.
Specific column details vary depending on the column type, but the structure remains the same.
Review column summaries and statistics
Reviewing column data allows you to view key column values and data summaries.
Review basic column data
View information about the column data and how it was calculated in the About section, which lists Type, Name, and Formula (fx).
Review column values
The Top values section is useful for visualizing the data distribution. The Top values list, available for text, number and date type columns, contains the column’s most common values, which can help identify trends or common characteristics.
A Value distribution histogram is also available for number and date columns, which can be useful for identifying outliers and data shape for that column.
Review data summary
The Summary section lists key column totals like Values, Nulls, Row count and Distinct values, which can be useful for evaluating data quality and diversity.
Values and Nulls indicate the number of non-null and null values in the column, respectively, and can indicate dataset completeness or need for further data cleaning.
Row count and Distinct values can give a sense of the size and diversity of the data in that column.
Review data distribution summary
The Statistics section lists a variety of column statistics. Minimum and maximum values are displayed for date and text columns. Those values, and the following other statistics, are available for number type columns:
- Minimum - The column’s minimum value. Depending on column type, this is the lowest number, the oldest date, or the first text value when sorted alphabetically (see Min).
- 25th percentile - The value below which 25% of the column’s values fall (see PercentileCont).
- Median - The midpoint in a sorted list of column values (see Median).
- 75th percentile - The value below which 75% of the column’s values fall (see PercentileCont).
- Maximum - The column’s maximum value. Depending on column type, this is the highest number, the newest date, or the last text value when sorted alphabetically (see Max).
- Average - The average of all column values (see Avg).
- Standard deviation - The column’s computed standard deviation (see StdDev).
- Variance - The column’s statistical variance (see Variance).
These statistics can be useful when performing further analysis into your data, by helping you understand the spread of data (25th percentile and 75th percentile), spot outliers (Minimum and Maximum), and evaluate data consistency (Variance and Standard deviation).