Configuring charts

configuring charts in your dashboard charts display the data within your dashboards when you add a chart, you select the data measures that are included, how those measures are aggregated (for example, total, % of total), and what dimension(s) to break the measures into each chart type contains different configuration dropdowns so that you can easily build and customize your chart you can add global data filters that apply to all charts within your dashboard, or use chart specific filters for each chart you can also configure charts to ignore global dashboard filters when they are applied add a chart to a dashboard you can add as many charts as you want to your dashboard to add and configure a chart access your dashboard select add chart in the chart type field dropdown, select the type of chart you want to create learn more https //docs charthop com/types of charts you can add to a dashboard you can select from the following options timeseries area chart line chart table vertical stacked bar chart non timeseries single metric horizontal bar chart pie chart table vertical bar chart in the configure chart section, define your y axis dropdown with the measures you want to include in your chart you can select from built in and custom fields within the dropdowns you can also enter the name of a built in or custom field to filter the dropdown list when a chart type includes a time series, the time period is automatically defined in the appropriate chart axis based on the time period you choose in the global filters select the value for how those measures are displayed (for example, total, % total, min, max) the options available by default are based on the data type associated with the measure you select the format field is also automatically defined based on the measure you select (optional) below the chart preview , you can choose your x axis and group by dropdowns, selecting additional measures to add more dimension to your data for example, selecting department displays the data in the chart grouped by department if you choose to add a measure in group by , you can customize the colors, the labels, choose what order you want the data to display in, as well as displaying the top values, grouping remaining values as other, and including “none” in your results (optional) select the show date range checkbox to display the date range directly within the chart (optional) select the show data labels checkbox to display data labels directly within the chart (optional) define the scale of your chart by entering the min and max values you want to use in the chart axis (optional) select the desired format metric format box if you want data to display differently than the default (optional) in the tooltip decimal places field, enter the number of decimal places to display for the values in your chart you can select between 0 and 5 places in the top right corner of the chart, select save & exit to add the chart and return to the dashboard (optional) repeat these steps to add additional charts customizing chart dimensions you can use carrot to customize the measures of a chart, which enables you to perform very detailed analyses of the data in your charthop org this feature is off by default to turn it on, select customized (advanced) on the chart for more information about carrot, see getting started with carrot learn more https //docs charthop com/carrot reference once you’ve enabled carrot, you can customize the current measures through carrot expressions you can also add a new value to the measures by selecting customize each item define the axis scale for a chart you have the ability to define the min and max values that are used in the axis of your area, line, and bar charts this helps with the readability of your charts and gives you more control over how you present your data by default, the axis scale is automatically determined based on the values of your data however, you can enter a custom min and max value in the axis scale fields when you’re configuring your chart to override those automatic values axis scales are maintained when you export your chart you can delete any values you have entered to return to the default axis scale values display data labels in a chart when you export a dashboard, exported charts display data labels depending on your configuration of the data labels checkbox when you hover over a chart, tooltips display data values with additional information however, you have the option to display data labels directly within the chart so that you can see this additional information without hovering to automatically display data labels in a chart, check the data labels checkbox you can check this option for all chart types except tables display date ranges in a chart to automatically display date ranges on a chart, check the date range checkbox you can check this option for all chart types for time series charts, or other charts that display data between two dates, it will display the range for non timeseries charts, it will display the end date that the data is from create a header to separate dashboard sections you can use headers to separate charts in your dashboard learn more about them here clone a chart in a dashboard you can clone an existing chart by selecting the chart menu (⋮) and selecting clone when you clone a chart, all chart settings and filters are maintained in the duplicated chart packages https //www charthop com/pricing/ basic | headcount planning | compensation reviews | performance | engagement