Create a grouped line chart in ArcGIS Dashboards

Summary

In ArcGIS Dashboards, grouped line charts can be added to a dashboard to display data with multiple categories on a single chart. The lines represent variables or categories and are distinguished by different colors on the chart.

This article describes the workflow to create a grouped line chart to compare the number of cases by month and year in ArcGIS Dashboards.

Procedure

When adding data to ArcGIS Dashboards, ensure the data is published to ArcGIS Online as a hosted feature layer or table. Refer to ArcGIS Online: Publish hosted feature layers for instructions. In this example, the Excel file is published as a hosted table.

Note:
When creating serial charts with numeric or sequential data such as months, years, or values, ensure the field type is an integer. Otherwise, add a new column with an integer field type representing each category.

1. Open ArcGIS Dashboards and create a dashboard. Refer to ArcGIS Dashboards: Create a dashboard for instructions.
2. On the dashboard toolbar, click the Layout panel and click Body.
3. Click Add element and select Serial chart from the drop-down list.

4. Click Browse all layers and select the desired hosted feature layer or table.
5. Configure the serial chart in the Serial chart window.
   1. Click the Data tab.
   2. For Categories from, select Grouped values.
   3. For Category field, click the drop-down list and select the field for the category axis (x-axis) of the chart. In this example, Month is selected.
   4. For Split by field, click the drop-down list and select the field to split the values into groups. In this example, Year is selected.
   5. For Statistic, click the drop-down list and select the type of statistic to be displayed. In this example, Average is selected.
   6. For Field, click the drop-down list and select the field for the value axis (y-axis) of the chart. In this example, Value is selected.

7. Click the Series tab.
8. For Type, click Line to display the chart as a line chart.

6. Rename the category axis.
   1. In the Serial chart window, click the Category axis tab and expand Labels.
   2. Click Load categories and type the labels in the Label column for each Category. In this example, category 12 is labeled as Dec, category 11 is labeled as Nov, and so forth, according to the sequence of months in a year.

7. Click Done to close the Serial chart window.
8. Click Save on the dashboard toolbar to save the configurations.

The image below displays the grouped line chart with the monthly and yearly trends in the number of cases.