How can I create a cumulative serial chart in ESRI dashboard. I have a date field, I want to display sum of cases per day.
I
That's the same thing I'm looking to do: basically a trend line....
So here's how I did it with my data. In this case I'm charting building permits issued by date.
1. Add a new chart to your dashboard
2. Point it to your data source
3. In the Data section, choose the category field; in my case Date Permits Issued (see below)
4. Then go to the Series section and check smoothed line.
My data looks like this:
Hi,
That is not cumulative chart.it just displays number of object, per day.
What cumulative does, it displays total of the feature, from the start, until today. It accumulates the data day by day.
So you want day 1, and then on day 2 you'll see day1+day2.... and on day10 that shows day1+day2+day3 ...+day10. Not sure how to do that. Sorry.
Derek Law any ideas?
Hi Nabaz and Joe,
> A cumulative chart ... it displays total of the feature, from the start, until today. It accumulates the data day by day.
Configuring this in the Serial Chart element on "raw" data is not possible. I think you would need to pre-process the data before adding it to dashboard. Maybe prep it in Excel first, then bring into ArcGIS. For example,
How to Make a Cumulative Chart in Excel | Chron.com
Hope this helps,
Looks like a solution was found here
https://community.esri.com/t5/arcgis-dashboards-questions/create-accumulative-charts-in-dashboards/m-p/1090789#M4980
Has this been updated? The last post was from 2021 and I know there have been updates since. We utilize the AGOL set up, not Portal and therefore the Arcade Scripting is a little difficult to manipulate in our case.
Hi there, has this been resolved yet? It's a capability for line graphs that a lot of end users are asking for.
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか?無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.