topic Re: ESRI dashboard create cumulative chart in ArcGIS Dashboards Questions

ESRI dashboard create cumulative chart

nabaz-gharib — Tue, 31 Mar 2020 14:27:46 GMT

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.

Re: ESRI dashboard create cumulative chart

JoeBorgione — Wed, 01 Apr 2020 15:17:03 GMT

That's the same thing I'm looking to do: basically a trend line....

Re: ESRI dashboard create cumulative chart

JoeBorgione — Wed, 01 Apr 2020 15:53:19 GMT

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:

Re: ESRI dashboard create cumulative chart

nabaz-gharib — Wed, 01 Apr 2020 16:41:39 GMT

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.

Re: ESRI dashboard create cumulative chart

JoeBorgione — Wed, 01 Apr 2020 17:15:55 GMT

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?

Re: ESRI dashboard create cumulative chart

DerekLaw — Thu, 02 Apr 2020 17:30:22 GMT

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,

Re: ESRI dashboard create cumulative chart

JoeBorgione — Thu, 02 Apr 2020 18:02:44 GMT

Yesterday I took a look at my dashboard and the data it references and realized right away that some sort of accumulation needs to take place at the data level. Thanks Derek Law‌. Seems like a challenging task as the data nabaz gharib‌ is working with is fluid....

Re: ESRI dashboard create cumulative chart

nabaz-gharib — Fri, 10 Apr 2020 20:16:16 GMT

Thank Derek for your reply.

Joe Borgione‌

The problem with your solution is the chart is not becoming dynamic. If I add new data to the feature layer i should update the chart manually.

However I figured out the good way to make it, using ChartJS, create a link and embed it in the dashboard. The chart access the data by using ArcGIS Rest API. So it is guaranteed to update automatically.

Re: ESRI dashboard create cumulative chart

Rudolfde_Munnik — Tue, 02 Jun 2020 12:01:38 GMT

Hi Nabaz,

I also require a cumulative chart dynamically without additional coding/scripting. I am very interested in how you used ChartJS and ArcGIS Rest API. Are you able to share the method.

Thank you

Rudolf

Re: ESRI dashboard create cumulative chart

JuanSthebanSanchezAragon — Fri, 20 Aug 2021 00:25:19 GMT

Hi Derek I´m new in Dashboard Arcade, but I´m wondering if there´s possible to get a solution through the new expression for serial charts for Dashboard which give a solution to accumulative charts. as nabazgharib needed and so do I in fact. Thanks for your time.

Note: This capability would be so amazing as it is a common chart in project following.

Re: ESRI dashboard create cumulative chart

DerekLaw — Wed, 25 Aug 2021 03:19:10 GMT

Hi @JuanSthebanSanchezAragon,

> I´m wondering if there´s possible to get a solution through the new expression for serial charts for Dashboard which give a solution to accumulative charts.

Support for cumulative sum charts is currently not supported in ArcGIS Dashboards. Sorry. But it is being considered in a future release. If you have specific requirements about this functionality, please send me your feedback and use case: dlaw@esri.com.

Hope this helps,

Re: ESRI dashboard create cumulative chart

LiamHarrington-Missin — Tue, 07 Mar 2023 17:09:00 GMT

Looks like a solution was found here

https://community.esri.com/t5/arcgis-dashboards-questions/create-accumulative-charts-in-dashboards/m-p/1090789#M4980

Re: ESRI dashboard create cumulative chart

KimmeSu — Wed, 08 May 2024 17:48:01 GMT

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.

Re: ESRI dashboard create cumulative chart

Laetitia_Osborne — Fri, 14 Jun 2024 12:12:03 GMT

Hi there, has this been resolved yet? It's a capability for line graphs that a lot of end users are asking for.