Simple value widgets

Simple value widgets allow you to highlight a single KPI or datum of interest. This can be of any data type, but a common example would be the count or average value of a KPI.

This is useful when you want to put a spotlight on a KPI in your Activeboard.

This is the source query used to generate the above widget:

query(
from demo.ecommerce.data
group every 30m by protocol every -
select count() as count
)

The image and background color are defined in the widget settings as Conditions. One condition applies the green background and the thumbs-up image when the count of events is greater than or equal to 4,000,000. The other condition applies the red background and the thumbs-down image when the count of events is less than 4,000,000.

What data do I need for this widget?

Any kind of data will work but the query must indicate a single datum.

Widget settings

The widget settings are contained in two tabs, Data and Visual. The settings in the Data tab are described in the Create a widget article.

These are the visual settings for the Simple Value widget:

Category	Setting	Description
Fields	Value	Select the field you want to represent in the widget.
Numbers	Number format	Select one of the following options: Rounded - Rounds the value to the number of decimal places indicated in the Decimal places field (for example: 2.52931 → 2.53 if you enter 2 in the Decimal places field). This is the default option. Original - Shows the original value with no decimal limitation. Humanize millisecond duration - Considers the value as a Unix timestamp in milliseconds and transforms it into a human-readable string (for example: a few minutes, 12 hours...) Seconds to DD HH:MM:SS - Considers the value as a Unix timestamp in seconds and transforms it into DD HH:MM:SS format. Milliseconds to date - Considers the value as a Unix timestamp in milliseconds and gives you the corresponding UTC date. Bits - Converts the value into an amount of bits. Bytes - Converts the value into an amount of bytes. Scientific - Shows the value written in scientific notation. Abbreviation - Formats values in thousands (K), millions (M)... Add separators - Adds the thousand separators corresponding to your browser's locale to values with four or more digits. Percentage - Multiplies the value by 100 and adds a percentage symbol. Currency - Adds the currency symbol that corresponds to your browser's locale.
Numbers	Decimal places	Specify the required number of decimal places to be shown when you select the Rounded option.
Colors	Color	Select the default color of the KPI text. This may be overridden when a KPI meets threshold condition. See the Conditions settings below.
Font	Size (px)	The default font size of the widget text.
Font	Weight	Sets the font weight used for displaying the KPI. Choose from Normal, Bold, and standard CSS font weights between 100 and 900.
Text	Link format	Turn on to transform a URL value into a hyperlink. This is only useful for values in URL format.
	Prefix	Enter any characters that should appear before the KPI value in the widget.
	Suffix	Enter any characters that should appear after the KPI value in the widget.
	Label	The label will appear below the KPI in normal font weight and black characters.
Conditions	Add conditional formatting to the appearance of this widget. Click the + icon to add a condition. Set the following fields for each condition.
	Operator and Value	Specify the condition by combining the Operator with the Value. For the operator, choose from > (greater than), < (less than), = (equal to) or != (not equal to).
	Color	Select the color of the KPI text when the condition is true.
	Background Color	Select the color of the widget background when the condition is true.
	Icon Url	Enter the URL of the image you want to include in the widget when the condition is true.