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.
Number 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 | 20 |
| Coffee | 30 |
| Cocoa | 10 |
- In the Data tab, change Operation from
SumtoAverage. The value changes from 60 to 20. - Change Operation to
Maximum. The value changes to 30. - 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
- 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:
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.
- 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:
OffOptions: 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:
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.
- 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- 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.
- 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.