Summary
Summary lists every column of a source with its type and its null, empty and distinct value counts.
Check a table for missing values
The source has four rows, and the last has neither a drink nor a cups value on purpose, so Summary reports the gap for each column.
Summary interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| Drink | Cups |
|---|---|
| Tea | 2 |
| Coffee | 1 |
| Tea | 3 |
- Read the Null column. A value such as "1 · 25%" means one row, or a quarter of the rows, is missing a value.
- Compare Empty with Null. Empty text and missing values are counted separately.
- Open the dropdown at the top of Properties and choose
Tableto see the rows behind the counts.
When to use
Use Summary to check a source before you trust a chart built on it. A chart can look fine even when a column is mostly missing values. To see which rows are affected, switch to Table.
Inputs
- Table
Accepts: Tables.
Accepts one connection on this port.
Settings
- Corner radius (px)
Corner radius in whole logical pixels.
Default:
0- Border width (px)
Border width in whole logical pixels.
Default:
0
Summary FAQs
- Do the counts cover my whole table?
- In the editor, previews use a sample of each source (100 rows by default), so counts can differ from a published dashboard, which uses all rows. See Your first dashboard.
- What is the difference between Null and Empty?
- Null means no value. Empty means text with no characters.
- Does Summary change my data?
- No. It only reports on the source.
Chart your data. Build it in Vista.
Vista opens in your browser, with no account.