Selecting Colors in Widgets

Applicable to Sisense on Linux and Microsoft Windows

Different field values are represented by different colors. The Widget Designer automatically assigns these colors and displays them in the widget legend that is displayed in the Widget Designer and in the dashboard.

The Widget Designer provides the following options for manipulating these colors:

Selecting a Specific Color – Single Color Tab

The following procedure describes how to assign a specific color to a data value that does not change. This color only applies to the widget in which it is defined.

To select a specific color:

  1. Click on a color in the Widget Designer Data Panel to display a color picker window.
  2. Select the Single Color tab.
  3. Select a color and click OK.
Note: To select a custom color that does not exist in the palette, enter a hexadecimal value into the # Custom field.

Selecting a Range of Colors – Range Tab

The Range tab is available for the following widgets:

The following procedure describes how to assign a range of colors to a field according to its value.

To select a color range:

  1. Click on a color in the Widget Designer Data panel to display a color picker window.
  2. Select the Range tab.
  3. By default, the range configuration is set to ‘Auto’, which automatically assigns a color range.
    Select Manual to manually configure the color range, as follows:

Defining Conditional Coloring – Conditional Tab

Define colors based on the value of the field as defined by a logical expression.

In addition, for Indicator widgets, you can also define whether an icon appears in the widget and select the icon’s color. For example, you can define a red arrow pointing downwards for a negative value.

For a short video overview of conditional coloring, see below:

To set conditional coloring:

  1. Click on a color in the Widget Designer Data panel to display a color picker window.
  2. Select the Conditional tab. Each row in this window represents a condition to which you can apply a value. If the condition is true, then that value is shown in the color that you select in this row. For example, one row can state that a negative value is displayed in red and another row can state that a positive value is green.
  3. In each row, define an expression to be applied to the value of this field by selecting an operator and specifying a value, as shown below.
  4. Select a color for the field.
  5. If required, add and define additional condition rows by clicking + Add condition.
  6. In the dashboard, these conditions are evaluated in the order in which they appear in this window – from top to bottom. The first condition that is true, determines the color. Reorder the condition rows as necessary by dragging them up or down.
  7. Click OK.