Single Value visualization

Best for visualizing an isolated piece of data.

The following options are available under each tab.

Note: The Single Value visualization always displays the value from the first row in the Data table. You can customize what is displayed in the visualization by adding a filter. For more information, see Filtering data. Single Value visualizations use the following data in order:
  1. Leftmost measure
  2. Leftmost dimension
Tip: Customize and edit the selected visualization type in the Edit Tile dialog box by clicking Edit.

Style

Options Description
Collection Select from a group of pre-selected colors.
Value Color

Choose one of several existing palettes or create a custom palette in the Custom tab. Customize using one of the following options:

  • Type in a hex code (for example, #b79d0f) or CSS color names (for example, mediumblue).
  • Click the Color Wheel button and click into the color wheel.
  • The color's brightness can be adjusted with the slider at the bottom.
Show Title Determines whether or not the title is displayed under the value. When a tile is saved, by default the title of the tile is used.
Title Override Insert a title you want to display with the value.
Note: This option is only available when Show Title is on.
Value Format Specifies the format of the value. For more information, see Numeric formatting for visualizations.

Comparison

Note: The Show Comparison needs to be enabled for other options to appear.
Options Description
Show Comparison Use a second field to add comparison information. This uses the next value in the table. If there is no other value to compare with in the current row, the application uses the value in the next row. Use filters or the hide visualization option to hide fields. For more information, see Filtering data.
Value Labels Specifies how the comparison field is used. Select one of the following options:
Note: The Calculate Progress and Calculate Progress (with Percentage) options require both the Percentage and Count measure to be selected.
  • Show as Value: The value of the comparison field is displayed at the bottom.
  • Show as Change. The value of the comparison field is displayed at bottom.
    • If it is negative: the number is displayed in red with a red triangle.
    • If it is positive: the number is displayed in green with a green triangle.
    Note: The colors can be changed using the Positive Values Are Bad field. It uses the raw value provided, unless you select a field.
  • Calculate Progress: The value of the field used is divided by the comparison field's value. It displays as a progress bar.
  • Calculate Progress (with Percentage): The value of the field is divided by the comparison field's value. The percentage is displayed as a progress bar. If Show Label is toggled on the progress bar also shows the label for the comparison field.
Positive Values are Bad Specifies the text and triangle colors displayed. When the toggle is on, it displays negative numbers as green text with a green triangle and positive numbers as red text with a red triangle.
Note: This option is only available when the Value Label is set to Show as Change.
Show Label Determines whether a label is shown with the comparison field. By default, the label is the name of the comparison field.
Label Enables you to provide a different label to the comparison field's name.
Note: This option is only available when the Show Label is toggled on.

Formatting

Note: The Enable Conditional Formatting toggle needs to be enabled for other options to appear.
Options Description
Enable Conditional Formatting Defines rules that color code the table.
Note: Conditional Formatting works only when subtotals are not displayed and Cell visualization in the Series tab is toggled off.

The following options are available when Conditional Formatting is enabled:

  • Include Totals: Rules are applied to Totals displayed in the table.
  • Include null values as Zero: Null values are represented as a zero.
  • The Rules section
Colors Select from a group of pre-selected colors to change the background or font color.
Table 1. Rules
Options Description
Move Drag and reorder rules.
Add Adds a rule.
Remove Removes a rule.
Format Specifies which numeric values the rule will apply to.

Additional fields can differ between values selected. The following Format fields can customize the Background color or Font color:

  • equal to
  • not equal to
  • greater than
  • less than
  • between
  • not between
  • null
  • not null
Background color Color of the background of the values.
Font color Color of the values.

NPS® drill down

If the visualization shows NPS℠1 Score data, users can drill down by clicking the NPS Score value. Up to 500 rows are displayed with the following information:

  • Date: The date the NPS response was recorded.
  • Respondent Member ID: The unique ID for the member.
  • Follow Up: The respondents' comments on the rating.
  • Response Status: The status of the survey (Complete, Incomplete, etc.).
  • Category: The NPS category of the response (Promoter, Passive, Detractor).
  • Median of NPS Response: The NPS score.

For more information, see Drilling into NPS score visualizations.

1 Net Promoter, NPS, and the NPS-related emoticons are registered U.S. trademarks, and Net Promoter Score and Net Promoter System are service marks, of Bain & Company, Inc., NICE Systems, Inc. and Fred Reichheld.