Number - Number

Visually displays a number, with fill color that can change automatically depending on the number value. This can be useful for highlighting values for infographics and dashboards.

Options

DATA SOURCE

Data The table or a part of the table containing the value to be shown.

Row/Column The row or column from Data which is to be shown. This can be set to a fixed row and column name or there is the option to Select using a Combo box or List box control or Select using a numeric index. If Data contains more than two dimensions, then additional controls similar to Row/Column will be shown.

FILL COLOR

Default fill color The default color used to fill the shape or number. This color will be used if no threshold(s) are supplied, or the input value is lower than any of the thresholds.

Threshold i The cut-off above which to use different fill color. These should be provided in increasing order.

Fill color i The fill color to use if the input value is above threshold i. For example if threshold 1 = 1, threshold 2 = 2, and default fill color is red, fill color 1 is yellow and fill color 2 is green. Then for an input value of 0.5, we would color the shape/icon red (default fill color), but for an input value of 5, we would use green (fill color 2) instead.

DATA LABEL

Data label prefix Optional string which will be prepended to the data label.

Data label suffix Optional string which will be appended to the data label.

Decimals shown The number of decimal places to show in the data labels.

Data label horizontal padding Adjusts the horizontal position of the data label in pixels. Negative values will move the data label left while positive values will move the data label right.

Data label vertical padding Adjusts the vertical space of the data label in pixels. Negative values will move the data label down while positive values move it higher.

Data label font Font settings for the data label. In this case, there is no option to select the data label font color because the fill color is used instead.

TEXT ABOVE/BELOW

Text above/below Optional text to place above or below the data label. This differs from the prefix/suffix in that it can have different font settings to the prefix and there are more options to customize the position.

Horizontal alignment One of Left, Center, Right.

Horizontal padding Adjusts the horizontal position of the text in pixels. Negative values will move the text left while positive values will move the text right.

Vertical padding Adjusts the vertical space between the text and the center of the widget in pixels. Increase to move the text away from the data label.

Font Font settings for the text.

HOVERTEXT

Hover text Optional text that can be shown when the mouse is placed over the data label.

Hover background color The fill color of box containing the hover text.

Hover font Font settings for the hover text.

BACKGROUND

Background color Controls color of the background.

Margins Controls how much space between the edge of the iframe and the shape or text. When Display is Number in a rectangle, you may need to increase the margins to see the background color. In some cases if the Text above/below is truncated, you may also need to manually increase the margins.