You are here:
Data Settings for Dashboard Line Chart Components
Line charts are useful for showing data over time.
Required Editions
| Available in: Salesforce Classic |
| Available in: Group (View Only), Professional, Enterprise, Performance, Unlimited, and Developer Editions |
| User Permissions Needed | |
|---|---|
| To create dashboards: | Run Reports AND Create and Customize Dashboards |
| To edit and delete dashboards that you created: | Run Reports AND Create and Customize Dashboards |
| To edit and delete dashboards that you created in public folders: | Edit My Dashboards |
| To edit and delete dashboards that you didn’t create in public folders: | Manage Dashboards in Public Folders |
| To create, edit, and delete dynamic dashboards: | Manage Dynamic Dashboards |
For example, to see the numbers of leads created each month in a report, set record count as the Y-axis and created month for the X-axis. The chart displays a line connecting the record count totals for each month.
| Setting | Description |
|---|---|
| Y-Axis | Choose what values to display on the vertical axis of your bar, column, scatter, or line chart. Depending on the chart type, axis values can be summary fields or groupings. To use the second grouping or summary field defined in the source report’s chart, select Auto. When the source report has a chart, Auto picks the values used by the chart. If the Y-axis corresponds to a custom summary formula that has the Where Will this Formula Be Displayed? option set to a grouping level other than All summary levels, then the X-axis and Groupings selection must correspond to that custom summary formula's grouping level. |
| X-Axis | Choose what values to display on the horizontal axis of your bar, column, scatter, or line chart. Depending on the chart type, axis values can be summary fields or groupings. To use the second grouping or summary field defined in the source report’s chart, select Auto. When the source report has a chart, Auto picks the values used by the chart. If the X-axis corresponds to a custom summary formula that has the Where Will this Formula Be Displayed? option set to a grouping level other than All summary levels, then the Y-axis and Groupings selection must correspond to that custom summary formula's grouping level. |
| Group By | Choose how to group information on your chart. This option is available only if the underlying report has more than one grouping. To use the second grouping or summary field defined in the source report’s chart, select Auto. |
| Combination Chart | Select this option to plot additional values on this chart. The chart type you chose must allow combination charts. |
| Display Units | Choose a scale for displaying your chart values. For table components, this setting applies only to the first column. For best results, choose Auto to let Salesforce select appropriate units. |
| Drill Down to | Select where users go when they click a dashboard component: the full source report for the dashboard component; the source report filtered by the group, X-axis value, or legend entry they clicked; the detail page for a chart or table element, axis value, or legend entry; or a URL that you specify. (You can't use URLs that begin with “mailto:” or “javascript:”.) Filtered and record detail page drill-down are disabled when viewing dashboard charts with more than 200 values. |
Did this article solve your issue?
Let us know so we can improve!
