Multiple series on a Grouped Values chart

727
4
02-17-2020 08:46 AM
Status: Open
New Contributor II

Charts sometimes need to be displayed using one value axis and two categories. An example would be values such as "Employment" and categories such as a month and a state. The chart is built normally using the categories from the "Grouped Values"

A list (of states) can is then added to the dashboard and an action tied to the serial chart to enable a filtered display of data from the second category in addition to the time series.

Importantly, with the "Grouped Values" option selected, the sum of the values axis is displayed when there is no selection in the list. In other words, if not state is selected, the sum for all the states in the serial chart data source for each month is displayed.

However, If two-series need to be displayed on a serial chart, then the "Categories from Features" option is used.

As is visible in the image above, when the "Categories from Features" is used, the chart displays values for all the categories (states) simultaneously. Ideally, the serial chart would display the sum of the values axis for the Month category, not the value for each state.

When a state is selected in the list, thereby filtering the values to just a single state, the chart renders as desired.

Two separate but similar proposals which could fix the behavior)

  1. Provide the option to use more than one series on a chart configured with "Grouped Values"
  2. When using the Categories from features, provide an option to display either one of these two mutually exclusive configurations  - the sum of features values or each category (the current default behavior)

Derek Law

4 Comments

This would be a great enhancement to Dashboards series!

Dear ArcGIS Dashboards‌, ArcGIS Dashboards Beta

please consider adding this functionality to new Dashboards. Now in COVID time, this is quite missing functionality. In our case, we are not able to display a history of confirmed cases, deaths and recovered in one line-chart. 

 

These attributes must be aggregated via DataField, and because for Aggregated values you can use just one statistic field, we must use several charts to display all these values. 

 

Please consider adding option to have more statistic fields also for aggregated data.

 

Thank you.

 

Regards,

 

Vladimir

Hi Tim,

Thanks for your post. Could you provide more info on your data model? It would help in assessing this request.

Based on the charts you included, I'm wondering if your data might be in the following format.

StateDateValue_SourceAValue_SourceB
California1-Apr5045
California2-Apr6054
California3-Apr7063
California4-Apr8072
Nevada1-Apr3531
Nevada2-Apr4237
Nevada3-Apr4944
Nevada4-Apr5650

If so, it might work to restructure your data. In the following format, we can leverage the "Split By" capability in the "Categories from Grouped Values" configuration.

StateDateValueSource
California1-Apr50A
California1-Apr45B
California2-Apr60A
California2-Apr54B
California3-Apr70A
California3-Apr63B
California4-Apr80A
California4-Apr72B
Nevada1-Apr35A
Nevada1-Apr31B
Nevada2-Apr42A
Nevada2-Apr37B
Nevada3-Apr49A
Nevada3-Apr44B
Nevada4-Apr56A
Nevada4-Apr50B

 

You would choose Categories from the Date field with a grouping period of Day. The statistic would be Sum on the Value field. Choose the Source field for the split by field. The chart would sum the values for each day (across all states) and have two series (or how ever many unique values in the source field): A and B. When a state is selected in the list, it would apply a filter action to the chart and you'd see data for only the selected state. 

Dear David Nyenhuis‌, I don´t know what is Tim Kuhn‌´s case, but to clarify ours see please below.

One of our examples:

 

Table with columns - county code, confirmedrecovereddeathsdatumregion code

Then we have numbers for each county and day. We have 77 counties in 14 regions.

 

Date is a category. And we would like to display timeline chart with sum of confirmed, recovered and deaths in each day (three lines/series in one chart). We have grouped values by date field, and there is a limit, that we can display just one statistic field and not more, that´s a limit. So, we must create more charts for each value.

See attached screen.

Missing Dashobard functionality

At best we would like to make within the same chart another 3 series of sumamrization based not one but two columns Region and Confirmed, Region and Recovered, Region and Deaths.

But this seems to be also above this idea, while dashboaed can´t make more statistic summarization based on one field. David Nyenhuis should we make another idea, or could be this merged with this idea?

Hope this helps to narrow the issue.

Thank you,

Vladimir