Documentation

    Number

    Number shows one headline value, such as a KPI, calculated from source rows, with an optional comparison and status.

    Show total cups sold

    Tea at 20 cups, Coffee at 30 and Cocoa at 10 add up to a single headline: 60 cups.

    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
    Tea20
    Coffee30
    Cocoa10
    1. In the Data tab, change Operation from Sum to Average. The value changes from 60 to 20.
    2. Change Operation to Maximum. The value changes to 30.
    3. Expand Comparison and use Compare to, to compare the value against another number.

    When to use

    Use Number for the one figure readers should see first, such as total revenue. If the figure needs a target, a range or a verdict to mean anything, use Progress, Gauge or Status.

    Inputs

    1 port
    TableOptional

    Accepts: Tables.

    Accepts one connection on this port.

    Settings

    Value

    Field to calculate. Automatic picks one, and Count rows needs none.

    Operation

    How the source rows become one value. Missing values are skipped.

    Default: Sum

    Options: Sum, Average, Median, Minimum, Maximum, 25th percentile, 75th percentile, 90th percentile, 95th percentile, Percentile, First by time, Last by time, Count values, Count distinct, Count rows, Count true, Percentage true.

    Label

    Text of the label.

    Headline text

    Shows text instead of a calculated number.

    27 more settings
    Compare to

    Optional change from the reference value. Percentage change isn't available when the reference is zero.

    Default: Off

    Options: Off, Absolute difference, Percentage difference.

    Source timezone

    IANA time zone for timestamps without an offset, such as Europe/Copenhagen. Ambiguous local times need an explicit offset.

    Default: UTC

    Chart timezone

    IANA time zone used for grouping and display. Vista filters keep their own time zone.

    Default: UTC

    Week starts

    Day the week starts on.

    Default: Monday

    Options: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

    Fiscal year starts

    Month the fiscal year starts in. Sets quarter and year boundaries.

    Default: January

    Options: January, February, March, April, May, June, July, August, September, October, November, December.

    Show tooltip

    Shows or hides values when you hover over a mark.

    Default: true

    Content

    Use the automatic details, or write your own text with calculated values.

    Default: Automatic

    Options: Automatic, Custom.

    Show status

    Gives the value a status using limits you set in its own units.

    Default: false

    Horizontal alignment

    Alignment of the content.

    Default: Center

    Options: Left, Center, Right.

    Vertical alignment

    Vertical position of the content in the card: top, center or bottom.

    Default: Center

    Options: Top, Center, Bottom.

    Value size

    Size of the value.

    Default: 28

    Label size

    Size of the label.

    Default: 12

    Value color

    Color of the value.

    Label color

    Color of the label.

    Show value

    Shows or hides the value.

    Default: true

    Show label

    Shows or hides the label.

    Default: true

    Content spacing

    Space between the parts of the card, in pixels (0-80).

    Default: 6

    Supporting text size

    Auto (0) matches Label size. Otherwise 10-80 pixels.

    Default: 0

    Number format

    Percentage shows fractions multiplied by 100. Calculations keep the original units.

    Default: Automatic

    Options: Automatic, Number, Percentage.

    Decimals

    Number of decimal places.

    Default: 0

    Digit grouping

    Groups digits, so 2630 shows as 2,630.

    Default: true

    Prefix

    Text before the value.

    Suffix

    Text after the value. Adding % doesn't multiply the value by 100.

    Scale

    Display unit for the value.

    Default: none

    Options: none, K, M, B.

    Background

    Card background color. Auto follows the theme.

    Corner radius (px)

    Corner radius in whole logical pixels.

    Default: 0

    Border width (px)

    Border width in whole logical pixels.

    Default: 0

    Number FAQs

    Can a KPI show a target or goal?
    Number has no target value. Its Goal setting says whether higher, lower or within a range is good, and Compare to shows the change against a reference. To show a KPI against a target, use Progress or Gauge.
    Can Number compare against another value?
    Yes. In the Data tab, expand Comparison and use Compare to.
    Why does my total differ from the published dashboard?
    In the editor, previews use a sample of each source (100 rows by default), so totals can differ from a published dashboard, which uses all rows. See Your first dashboard.
    How are missing values handled?
    Numeric calculations ignore missing values.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.