{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":35348,"path":"now-intelligence/config-dv-pareto-ind-data.md","title":"Indicator data options for pareto bar visualizations","bundle":null,"doc_type":null,"release":"australia","body":"\n# Indicator data options for pareto bar visualizations\n\nWhen you select an indicator data source for a Pareto bar visualization, the following Data configuration options are available.\n\n**Note:** Fields that apply to Data snapshots indicators apply only to native Data snapshots indicators, not classic indicators with Data snapshots enabled.\n\nThe data source for a native Data snapshots indicator has the indicator type **Automated - Data Snapshots** or **Formula - Data Snapshots**.\n\n\\[Omitted image \"ds-source-native.png\"\\] Alt text: Data source properties for a native Data snapshots indicator\n\nThe data source for a classic indicator with Data snapshots enabled has the indicator type of either **Automated** or **Formula**.\n\n\\[Omitted image \"ds-source-enabled.png\"\\] Alt text: Data source properties for an enabled Data snapshots indicator\n\n\n
\n\nField\n\n\n\nDescription\n\n
\n\nData\n\n
\n\nData source\n\n\n\nYou have selected an Indicator or Usage Insights data source in [Create a horizontal or vertical bar data visualization](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/create-dv-bar-ac.md).\n\n **Note:** Only one data source can be defined pareto at any given time.\n\n
\n\nMetric\n\n
\n\nLabel\n\n\n\nLabel of the metric. By default it is the same as the name of the data source.**Note:** Only one metric can be defined for a Pareto bar visualization at any given time.\n\n
\n\nTime aggregation\n\n\n\nTime aggregation to apply to the metric, such as 7-day running SUM or By-month AVG. Default is the same as the indicator period. For more information, see [Applying time series aggregations](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/performance-analytics/applying-time-series-aggregations.md).\n\n
\n\nSelect an aggregation \\(Data snapshots indicators only\\)\n\n\n\nThe aggregation is based on the Data snapshots indicator's configuration. You cannot change it in the context of creating a data visualization. **Count** counts the number of records. **Count distinct** counts the number of unique values rather than the total number of records. For example, if the name of a user appears more than once in a list, the user is only counted once. Other choices perform the specified aggregate operation, such as summing the values in a field across records.\n\n
\n\nField \\(Data snapshots indicators only\\)\n\n\n\nThe field on the Data snapshot's source to which the aggregate is applied. Required for all aggregates except Count.\n\n
\n\nShow incomplete periods \\(Data snapshots indicators only\\)\n\n\n\nSelect to display values from the period in progress. Clear this check box to show only the values for completed periods.\n\n
\n\nFormat values\n\n\n\nSelect to open the **Formatting values** dialog. For more information, see [Value formatting in reports](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/reporting/value-formatting-reports.md).\n\n
\n\nFormatting values\n\n
\n\nUse custom formatting\n\n\n\nOption to use custom formatting on the component.\n\n
\n\nDecimal precision\n\n\n\nNumber of decimals to show in the metric. This field is available only when the **Use custom formatting** option is activated.\n\n
\n\nRounding\n\n\n\nType of rounding to use to reach the number of decimals in the **Decimal precision** field. Options include:- Up `UP`\n- Down `DOWN`\n- Ceiling `CEILING`\n- Floor `FLOOR`\n- Half up `HALF_UP`\n- Half down `HALF_DOWN`\n- Half even `HALF_EVEN`\n\n **Note:** Only available when **Use custom formatting** is true.\n\n
\n\nUse the thousands group separator\n\n\n\nOption to use a comma to separate groups of thousands.**Note:** Only available when **Use custom formatting** is true.\n\n
\n\nEnable abbreviation\n\n\n\nOption to use an alphabetical abbreviation. For example, M to represent million. **Note:** Only available when **Use custom formatting** is true.\n\n
\n\nExample\n\n\n\nExample of the final value to show in the component. **Note:** Only available when **Use custom formatting** is true\n\n
\n\nGroup by\n\n
\n\nBreakdown\n\n\n\nList of breakdowns to choose from for grouping indicator scores.**Important:**\n\n- Scripted breakdowns are not supported in dashboard filters.\n- Only two levels of breakdown are supported in total, including data visualization and dashboard filters.\n\n Each breakdown element is shown separately in the visualization. If a multiple select filter for that breakdown is also applied to the visualization, only the selected elements are shown. If you do not specify a breakdown in this field and apply a multiple select filter, the aggregate score of all selected breakdown elements is shown. For more information, see [Viewing multiple breakdown elements](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/performance-analytics/view-multiple-breakdown-elements.md).\n\n Data snapshots indicators support only reference, Boolean, and choice fields for group bys.\n\n **Note:** For Data snapshots indicators, breakdowns are specified on the indicator source. For classic Performance Analytics indicators, breakdowns are specified on the indicator record.\n\n
\n\nAdd alternative group by\n\n\n\nThis 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.\n\nData snapshots indicators support only reference, boolean, and choice fields for alternative group bys.\n\nFor more information about setting alternative group-bys for multiple metrics, see [Options for time series data visualizations with multiple metrics](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/chart-options-multi-metrics.md). 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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/select-group-runtime.md).\n\n**Important:**\n\n- Only up to three metrics on one visualization support alternative group-by.\n- Alternative group-by does not support data binding on the data source\n\n
\n\nDate range\n\n
\n\nApply date range\n\n\n\nWhen turned on, this option allows date filters on the dashboard or UIB page to apply to this visualization. The date range can also be configured in the visualization, but date filters override visualization settings.\n\n
\n\nShow data for selected period as\n\n\n\nAvailable when **Apply date range** is selected.The indicator aggregation logic for how scores from the selected period are shown, such as Latest score, Sum, or Average.\n\n
\n\nSet absolute period\n\n\n\nOption to set absolute start and end date.Available when **Apply date range** is selected.\n\n
\n\nPeriod start\n\n\n\nStart date for the absolute period.This property applies only when **Set absolute period** is true.\n\n
\n\nPeriod end\n\n\n\nEnd date for the absolute period.This property applies only when **Set absolute period** is true.\n\nSelect **Use current date for period end** to automatically update the end date to the current date. \\(Not available if the start date is in the future.\\)\n\n
\n\nNumber of periods\n\n\n\nNumber of date periods to display. This property applies only when **Set absolute period** is true.\n\n
\n\nPeriod\n\n\n\nTime interval for each date period. - Days `D`\n- Months `M`\n- Years `Y`\n\n This property applies only when **Set absolute period** is false.\n\n
\n\nData update\n\n
\n\nFollow filters\n\n\n\nFollow 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.\n\n
\n\nShow filter icon\n\n\n\nOption 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.\n\n
\n\nRefresh after being away for X min.\n\n\n\nTriggered 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.\n\n
\n\nInfo messages\n\n
\n\nSet custom message when no data\n\n\n\nOption to configure a custom message that displays when no data is returned.\n\n
\n\nIllustration\n\n\n\nAn illustration to include in the message.\n\n
\n\nHeading\n\n\n\nHeader text of the message that describes why no data was returned.\n\n
\n\nContent\n\n\n\nSecondary text of the message that provides additional detail.\n\n
\n\nAlignment\n\n\n\nThe alignment of the illustration and text in the message.\n\n
**Parent Topic:**[Create a Pareto bar data visualization](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/now-intelligence/create-dv-pareto-vd.md)\n\n"}}