I am relatively new to AGOL and dashboards, and I have encountered an issue I haven't been able to solve. Here’s the situation:
We are working on a traffic crash dashboard with two serial charts that we want to combine into a single chart. The two charts were created using the same layer/attribute table.
The first chart displays the number of fatal crashes per year. This chart is a count of the records in the attribute table (each record represents one fatal crash).
The second chart displays the number of fatalities per year (i.e., the total number of people killed in the fatal crashes). This chart is the sum of the fatalities field of the same attribute table.
The vast majority of our fatal crashes have one fatality, but a few have two or three. Thus, in a typical year, we may have 30 fatal crashes with 34 fatalities. Because the number of fatal crashes and the number of fatalities are always relatively close to each other, we would prefer to show the data in a single serial chart – perhaps using bars for the number of crashes per year, and a line for the number of fatalities per year.
Can this be done?
