Table data options for bubble visualizations
When you select a table data source for a bubble visualization, the following Data configuration options are available.
| Field | Description |
|---|---|
| Data | |
Data source |
You’ve selected a Table data source in Create a bubble visualization in the Visualization Designer. |
| Metric | |
| Metric (bubble size) | Choose the computational method for aggregating data and the field that
determines the size of bubbles in the visualization. The default aggregation 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. |
| 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:
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 |
Dimensions |
|
| Y axis | Numeric table field with values on the bubble chart's y-axis. |
| X axis | Numeric table field with values on the bubble chart's x-axis. |
| Group by | Any table field other than the x- and y-axes. Different groups are distinguished by bubble color. |
| Add alternative group by | This selection opens a dialog in which you select additional items that the data in the visualization may be grouped by. The viewer of the visualization can then select which of these items to group the
data by. The viewer toggles the visibility of the selector in the visualization's More actions menu. In the additional items dialog, you can set whether this selector is visible by default by toggling
Selector visible by default. If you select a value in Group by, that is the default group-by value. You do not have to select a Group by value to specify alternative group-by values. In this case, no default group-by value is used. For more information about setting alternative group-bys for multiple metrics, see Options for time series data visualizations with multiple metrics. For more information about the viewer experience selecting from alternative group-by values, see Select a group-by value in a data visualization as a viewer. Important:
|
| 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. |
| 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. |