--- sourceDocument: Xanadu Platform Analytics sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence Release : - xanadu ft:locale : - en-US ft:publication_title : - Xanadu Platform Analytics ft:clusterId : - par bundleId : - par workflow : - Platform --- # Table data options for pie and donut visualizations # Table data options for pie and donut visualizations {#ariaid-title1} * Release version: Xanadu * * Updated August 1, 2024 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 5 minutes to read When you select a table data source for a pie or donut visualization, the following Data configuration options are available. {#config-dv-donut-table-data__desc}{#config-dv-donut-table-data__heading-data}{#config-dv-donut-table-data__entry_format-values}{#config-dv-donut-table-data__entry_decimal-precision} | Field | Description | |-|-| | Data || | Data source | You have selected a Table data source in [Create a pie or donut visualization in the Visualization Designer](https://servicenow-prod.fluidtopics.net/LbZ91IlgaziHu3BmDqApeA "Use pie, donut, and semi-donut visualizations to compare the size of parts of a data set to the whole. The segments of these charts should total to 100%."). | | 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](https://servicenow-prod.fluidtopics.net/iyxA5tkjQ6sEXDrRejhocw "While regular fields store a value in the database, a function field displays the results of a database query. The function field generates the value based on computations of other fields and constants. You can use these fields in reports and data visualizations as you would other fields."). | | Format values | Select to open the Formatting values dialog. For more information, see [Value formatting in reports](https://servicenow-prod.fluidtopics.net/AtIreDMjQHHIo~Tns9Vtyg#value-formatting-reports "In most reports, you can configure how numerical values look when you publish the report."). | | 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` {#config-dv-donut-table-data__ul_l4g_3tk_grb} 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 | | Group by || | Field for \[table\] | The field to group by. For example, in an incident report grouped by Assignment group, all incidents that belong to Software, Service Desk, and Network are placed in separate groups. If the table contains variables or question fields, you have the option to group by one of them at the end of the list of fields. Note: * It is not possible to group or stack data by the Tags field, or by certain field types, such as MEDIUMTEXT. * If the field contains a continuous value, such as a date or integer field, report ranges for the field are used automatically if available. For more information, see [Report ranges](https://servicenow-prod.fluidtopics.net/Pwo4sj9SztlcL3vDesOAhw#c_ReportRanges "Use a report range to define data intervals that are used in bar, donut, and pie charts in Platform Analytics data visualizations and Core UI reports."). {#config-dv-donut-table-data__ul_ntk_451_n2c} | | Max number of groups | Select the maximum number of groups to display. Groups in excess of this number, determined by sorting, are aggregated into the Others group. You can show that aggregate with the Show others option. By default, you cannot show more than 50 groups. If you have the admin role, you can change this limit in the par_viz.table_data.max_groups system property. | | Show others | If Max number of groups is set and this option is turned on, an aggregate of the groups beyond the maximum number is displayed as the Others group. | | Hide elements with 0 values | When toggled on, elements with a value of NULL or 0, such as rows or data points, are not displayed. Does not apply when the metric is COUNT. | | 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 the viewer experience selecting from alternative group-by values, see [Select a group-by value in a data visualization as a viewer](https://servicenow-prod.fluidtopics.net/~NbuZAiGec19xALRh7AaCA "A viewer of a data visualization can select the value for grouping the data in the visualization."). | | Sorting || | Sort by | Groups or categories to sort by in the specific order. Options include Name, Value, and Group bucket. | | Sort by order | Ascending or descending. | | Additional settings || | Show total value | Option to show the overall total value. Value is still hidden if it does not fit in the donut, due to width/height settings, page resizing, or similar issues. Clicking the total value opens a list of contributing table records or KPI Details for the indicator. | | Show metric label | Option to show the metric label. In donut charts, the value is not shown if it cannot fit the donut. | | 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 || | 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. | [ ] {#config-dv-donut-table-data__table_wqy_sjr_qtb}