Simple value widgets

[ 1 What data do I need for this widget? ] [ 2 Widget settings ] [ 3 Query example ]

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.

What data do I need for this widget?

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

Widget settings

To edit the widget settings, you must first be in Edit mode.

Click the widget title bar to open its settings. Alternatively, the settings are accessible via the Ellipsis icon → Properties. The widget settings are contained in three tabs, Data, Visual, and Raw.

The settings in the Data and Raw tabs are described in the Create a widget article. These are the Visual settings for the Simple Value widget:

Category	Setting	Description

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 a number of bits. Bytes - Converts the value into a number of bytes. Scientific - Shows the value written in scientific notation. Abbreviation - Formats values in thousands (K), millions (M)... Add separators - Adds the thousand separator 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 the 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.
Link	Link format	Turn on to transform a value into a hyperlink. Once activated, you can modify the link pattern. By default, the pattern will be $ value, where this value becomes a link. The default URL protocol is https//: and other supported protocols are http, htpps and fttp.
Text	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 & 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.

Query example

This is the source query used and the fields mapped to generate the widget shown above:

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

Value	count
Conditions	green background and the thumbs-up image when the count of events is greater than or equal to 4,000,000 red background and the thumbs-down image when the count of events is less than 4,000,000.