Insights - Selecting Colors in Widgets

Updated 10 months ago by Elena Yurkova

Widget's colors

Using colors strategically can significantly amplify the perceived value of your dashboards. Colors help to focus user's attention and interpret data faster.

Different widgets are represented by different colors. The Widget Designer automatically assigns these colors, but the colors can be easily changed and even customized.

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

  • Single Color: For selecting a specific color for all values
  • Range: For selecting a range of colors
  • Conditional: For defining colors based on conditional data.

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.
    To select a custom color that does not exist in the palette, enter a hexadecimal value into the # Insert Custom field.

Selecting a Range of Colors – Range Tab

The Range tab is available for the following widgets:

  • Column Chart and Bar Chart
  • Scatter Map and Area Map

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. To modify settings select 'Manual' to manually configure the color range, as follows:
  • Change Colors: Click the color rectangles at the right and left to change the start and end color of the range.
  • Customize Range: By default, the color range is set to match the minimum and maximum values of the data. Instead, you can manually set a minimum value. All values that are below this value will be assigned to the color on the left. Accordingly, selecting a Max value means that all values larger than it will be assigned the color on the right. By default, the ‘Middle’ color is grey. All values larger than this will start gradually getting the right color. All values smaller than this will start gradually getting the left color. Changing the ‘Middle’ value controls which value the color gray is assigned to.
  • Coloring Method: Selecting Min/Max will display the full-color range. Selecting Min will display all the colors between the minimum and middle values, and higher than the middle value will be gray. Selecting Max will display all values between the middle value and the maximum value, while all other values will be displayed in gray.
  • Transition: Select Steps to define a distinct number of colors in the range. Select Gradient for a linear color range.

Defining Conditional Coloring – Conditional Tab

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

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. 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 to be applied if this condition is true.
  5. If required, add and define additional condition rows by clicking + Add condition.
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.
  1. Click OK.

Besides static values, you can also set colors based on the condition, for example if sales this year exceed sales from the previous period. In this case, your calculated value in the widget will be compared with the result in the formula. To enter the formula click on 'fx' icon and remember to order your conditions from the top down.


How did we do?