When you select a table data source for a single score visualization, the following Data configuration options are available.

Field Description
Data

Data source

You have selected a Table data source in Create a single score data visualization in the Visualization Designer or on a dashboard.
Metric
Label Label of the metric. By default it is the same as the name of the data source.
Select an aggregation Computational method for aggregating data. The default is Count, which displays the number of records selected.
Note: If you select Count Distinct, only unique records are counted. For example, you want to generate a report with a distinct number of users who have one or more of the roles in a given list of roles. Users with more than one role would be counted twice unless you use Count Distinct.
Field Field to apply the metric to, for Average, Sum, or Count Distinct aggregations. You may further be able to aggregate on fields from extended tables.

The data is shown in a format that matches the field type. For example, if you select an integer field, such as the Priority field, the data is expressed as a number. If you select a duration field, such as Business duration on the Incident table, the aggregated data is expressed in days, hours, and minutes.

If function fields were created in Report Designer for the table, they are available in the dropdown list. For more information, see Report on function fields.
Format values Select to open the Formatting values dialog. For more information, see Value formatting in reports.
Formatting values
Use custom formatting Option to use custom formatting on the component.
Decimal precision Number of decimals to show in the metric. This field is available only when the Use custom formatting option is activated.
Rounding Type of rounding to use to reach the number of decimals in the Decimal precision field. Options include:
  • Up UP
  • Down DOWN
  • Ceiling CEILING
  • Floor FLOOR
  • Half up HALF_UP
  • Half down HALF_DOWN
  • Half even HALF_EVEN
Note: Only available when Use custom formatting is true.
Use the thousands group separator Option to use a comma to separate groups of thousands.
Note: Only available when Use custom formatting is true
Enable abbreviation Option to use an alphabetical abbreviation. For example, M to represent million.
Note: Only available when Use custom formatting is true
Example Example of the final value to show in the component.
Note: Only available when Use custom formatting is true

Additional settings
Show metric label Option to show the metric label. In donut charts, the value is not shown if it cannot fit the donut.
Show score update time Option to display the time of the last update.
Use relative score time Available if Show score update time is selected. Select to show how long ago the score was last updated.
Show zero When toggled on, shows empty (NULL) values as zero (0). Default is true.
Data update
Follow filters Follow filters set for a page. When enabled, the visualization displays on a workspace with the filters set by the page. Toggle off to disable a visualization from accepting any filter input.
Show filter icon Option to show the filter icon and the number of filters impacting the visualization. If a filter is not selected to apply to a visualization, the icon does not show. Toggle off to hide the filter icon and number of filters applied.
Refresh after being away for X min. Triggered when you navigate away from the dashboard that contains the data visualization to another page in the same workspace, includingPlatform Analytics experience. Sets how many minutes you will be on another page before the visualization automatically refreshes when you navigate back.

Do not confuse this property with the Scheduled repetition setting on inline dashboards. This latter property refreshes the entire dashboard, and applies only while that dashboard is open.
Real-time update Option to update score in real time. If you enable both real-time update and data caching, real-time update overrides data caching.
Note:
  • When a condition is dot-walked to another table, high traffic on the table suspends real-time data updates.
  • Real-time updating does not support MIN, MAX, or COUNT DISTINCT aggregations.
No data message

This section is not available when Show zero is on. Zero is then the no data message.
Set custom message when no data Option to configure a custom message that displays when no data is returned.
Illustration An illustration to include in the message.
Heading Header text of the message that describes why no data was returned.
Content Secondary text of the message that provides additional detail.
Alignment The alignment of the illustration and text in the message.