Statistics dialog - all data types

Every data type in one frame: header, tiles, a metrics grid, a chart and a note, with the unique values on the right when some value repeats. Numbers come from the real fixtures. Click any part of a dialog to comment.

Integer - age · sample_data.parquet · 1,500 rows
ageintCopy stats as JSON×
Total rows
1,500
100% of all rows
Non-null
1,500
100.0% of all rows
Null
0
0.0% of all rows
Unique
63
4.2% of non-null values
Distributioninteger values, five-year bins
Min
18
Q1
34
Median
49
Q3
64
Max
80
Mean
48.91
Std dev
17.77
Outliers
0 (0%)
1835506580
1,500 rows in 13 bins of 5 years
1880
medianmean
Unique values
6 of 63 listed, ranked by count
ValueShare of rowsCount%
52312.07%
65312.07%
48302.00%
50291.93%
23281.87%
30281.87%
Sample data - the age column of sample_data.parquet.
Float - salary · sample_data.parquet · 1,500 rows
salaryfloatCopy stats as JSON×
Total rows
1,500
100% of all rows
Non-null
1,500
100.0% of all rows
Null
0
0.0% of all rows
Unique
1,500
100.0% of non-null values
Distributionfloat values, ten-thousand bins
Min
30,015.73
Q1
58,344.13
Median
87,494.20
Q3
118,945.06
Max
149,986.74
Mean
88,588.34
Std dev
34,274.03
Outliers
0 (0%)
30k60k90k120k150k
1,500 rows in 12 bins of 10,000
30015.7149987
medianmean
Sample data - the salary column of sample_data.parquet.
Decimal - price · adaptive_types.parquet · 12 rows
pricedecimalCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
12
100.0% of all rows
Null
0
0.0% of all rows
Unique
12
100.0% of non-null values
Distributiondecimal128(10, 2) values
Min
9.99
Q1
17.56
Median
23.75
Q3
36.88
Max
99.99
Mean
32.52
Std dev
24.45
Outliers
1 (8.3%)
10305080100
12 rows in 9 bins of 10
9.9999.99
medianmean
Sample data - the price column of adaptive_types.parquet.
Duration - elapsed · typed_columns.parquet · 12 rows
elapseddurationCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
12
100.0% of all rows
Null
0
0.0% of all rows
Unique
12
100.0% of non-null values
Distributiondurations shown as the grid shows them
Min
0:00:00
Q1
0:13:45
Median
0:27:30
Q3
0:41:15
Max
0:55:00
Mean
0:27:30
Std dev
0:17:15
Outliers
0 (0%)
0:000:140:270:410:55
12 rows in 10 bins of 330 seconds
0:000:55
medianmean
Sample data - the elapsed column of typed_columns.parquet.
Time - clock · typed_columns.parquet · 12 rows
clocktimeCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
12
100.0% of all rows
Null
0
0.0% of all rows
Unique
12
100.0% of non-null values
Distributionone row per minute between the earliest and latest
Earliest
09:00:00
Latest
09:11:00
Span
11 minutes
09:0009:0309:0609:0909:11
12 times in 12 one-minute bins
Sample data - the clock column of typed_columns.parquet.
Date - join_date · sample_data.parquet · 1,500 rows
join_datedateCopy stats as JSON×
Total rows
1,500
100% of all rows
Non-null
1,500
100.0% of all rows
Null
0
0.0% of all rows
Unique
1,028
68.5% of non-null values
Distributionrows per year between the earliest and latest
Earliest
2020-01-02
Latest
2024-12-05
Span
1,799 days
20202021202220232024
1,500 dates in 5 one-year bins
Sample data - the join_date column of sample_data.parquet.
Datetime - created · adaptive_types.parquet · 12 rows
createddatetimeCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
12
100.0% of all rows
Null
0
0.0% of all rows
Unique
12
100.0% of non-null values
Distributionrows per day between the earliest and latest
Earliest
2026-01-01 09:00
Latest
2026-01-12 09:11
Span
11 days
Time of day
09:00 - 09:11
Jan 1Jan 5Jan 9Jan 12
12 timestamps in 12 one-day bins
Sample data - the created column of adaptive_types.parquet.
Text - department · sample_data.parquet · 1,500 rows
departmentstringCopy stats as JSON×
Total rows
1,500
100% of all rows
Non-null
1,500
100.0% of all rows
Null
0
0.0% of all rows
Unique
5
0.3% of non-null values
Textfive values, 20.5 percent at most
Most common
Finance
Top share
20.5% of non-null
Min length
2
Max length
11
Avg length
6.8
Unique values
5 of 5 listed, ranked by count
ValueShare of rowsCount%
Finance30720.47%
Sales30520.33%
HR30020.00%
Marketing29619.73%
Engineering29219.47%
Sample data - the department column of sample_data.parquet.
Text that reads as numbers - zip · adaptive_types.parquet · 12 rows
zipstringCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
12
100.0% of all rows
Null
0
0.0% of all rows
Unique
3
25.0% of non-null values
Numeric valuesdigits in a text column, read as numbers
Min
2
Q1
5.75
Median
8.5
Q3
10
Max
10
Mean
7.25
Std dev
3.27
Outliers
0 (0%)
210
medianmean
Unique values
3 of 3 listed, ranked by count
ValueShare of rowsCount%
010650.00%
002325.00%
007325.00%
Sample data - the zip column of adaptive_types.parquet.
Boolean - is_active · sample_data.parquet · 1,500 rows
is_activebooleanCopy stats as JSON×
Total rows
1,500
100% of all rows
Non-null
1,500
100.0% of all rows
Null
0
0.0% of all rows
Unique
2
0.1% of non-null values
Valuestrue and false with their share of non-null
true73448.9%
false76651.1%
No unique list: the two bars already are the whole value set.
Sample data - the is_active column of sample_data.parquet.
List served as JSON text - tags · adaptive_types.parquet · 12 rows
tagsstringCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
12
100.0% of all rows
Null
0
0.0% of all rows
Unique
3
25.0% of non-null values
Textthe grid shows the list as JSON text
Most common
["a", "b"]
Top share
41.7% of non-null
Min length
2
Max length
10
Avg length
6.3
Unique values
3 of 3 listed, ranked by count
ValueShare of rowsCount%
["a", "b"]541.67%
["b"]433.33%
[]325.00%
Sample data - the tags column served as text.
Binary - content · documents table · 1,000 blobs · approved Option A
contentbinaryCopy stats as JSON×
Total rows
1,000
100.0% of all rows
Non-null
1,000
100.0% of all rows
Null
0
0.0% of all rows
Sizemeasured with length(); contents are never decoded
Min
512 B
Q1
3.1 KB
Median
12.0 KB
Q3
96.2 KB
Max
4.8 MB
Mean
208.4 KB
Std dev
421.7 KB
Total
203.5 MB
512 B4 KB32 KB256 KB2 MB4.8 MB
1,000 blobs in log2 bins
No unique count: the grid shows one placeholder per size, so a count would measure sizes, not contents.
Sample data - a documents table holding 1,000 PDF blobs.
All-null - blank · adaptive_types.parquet · 12 rows
blankstringCopy stats as JSON×
Total rows
12
100% of all rows
Non-null
0
0.0% of all rows
Null
12
100.0% of all rows
Unique
0
0.0% of non-null values
No values to summarize: every cell is null.
Sample data - the blank column of adaptive_types.parquet.