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%.
Progress 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.
| Channel | Raised EUR |
|---|---|
| Online | 25 |
| Shop | 15 |
| Event | 20 |
- Read the visual: it shows €60, the Target label, €100 and 60%.
- Expand Target in the Data tab and change Reference value, for example to
120. The percentage updates. - 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
- 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:
SumOptions: 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 valueOptions: 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:
MondayOptions: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
- Fiscal year starts
Month the fiscal year starts in. Sets quarter and year boundaries.
Default:
JanuaryOptions: 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:
AutomaticOptions: Automatic, Custom.
- Goal
Whether higher or lower is good.
Default:
Higher is betterOptions: 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:
CenterOptions: Left, Center, Right.
- Vertical alignment
Vertical position of the content in the card: top, center or bottom.
Default:
CenterOptions: 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:
BelowOptions: Below, Inside.
- Number format
Percentage shows fractions multiplied by 100. Calculations keep the original units.
Default:
AutomaticOptions: 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:
noneOptions: 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.