Documentation

    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.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    DrinkCups
    Tea2
    Coffee1
    Tea3
    1. Read the Null column. A value such as "1 · 25%" means one row, or a quarter of the rows, is missing a value.
    2. Compare Empty with Null. Empty text and missing values are counted separately.
    3. Open the dropdown at the top of Properties and choose Table to 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

    1 port
    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.