Documentation

    Progress

    Progress calculates a value from source rows and shows how far it has moved from a start value toward a target.

    Track money raised against a target

    Online raised €25, the shop €15 and an event €20, which adds up to €60 against a €100 target, or 60%.

    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
    ChannelRaised EUR
    Online25
    Shop15
    Event20
    1. Read the visual: it shows €60, the Target label, €100 and 60%.
    2. Expand Target in the Data tab and change Reference value, for example to 120. The percentage updates.
    3. Expand Goal to set whether higher or lower values count as good.

    When to use

    Use Progress to show how close you are to a goal, such as money raised against a target. For a figure with no target, use Number. For a position on a fixed scale with no finish line, use Gauge.

    Inputs

    1 port
    Table

    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.

    40 more settings
    Reference source

    A fixed value you enter, or a value calculated from a field in the same source.

    Default: Fixed value

    Options: Fixed value, From field.

    Reference value

    Value to compare with.

    Default: 100

    Reference caption

    Text shown with the reference.

    Default: vs target

    Start value

    Progress starts here and is complete at the target. The goal sets the direction.

    Default: 0

    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.

    Goal

    Whether higher or lower is good.

    Default: Higher is better

    Options: Higher is better, Lower is better.

    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

    Show target text

    Hides the reference text. The comparison is still calculated.

    Default: true

    Show percentage

    Shows or hides the percentage.

    Default: true

    Percentage placement

    Inside moves the label below the bar when it can't fit at its set size.

    Default: Below

    Options: Below, Inside.

    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.

    Accent color

    Accent color.

    Track color

    Color of the track.

    Bar height

    Height of the bar, in pixels (4-120).

    Default: 12

    Bar width

    Width of the bar, as a percent of the content width (10-100).

    Default: 50

    Corner radius

    Corner radius, in pixels (0-60). The bar's size limits how round it can look.

    Default: 6

    Show track

    Shows or hides the unfilled part of the bar.

    Default: true

    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

    Progress FAQs

    Can the target come from my data?
    Yes. Under Target you can use a fixed number or calculate it from a field.
    Does the start have to be zero?
    No. Progress is measured from the start value to the target.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.