Sum values within a dashboard list using arcade

Anonymous User — Fri, 27 Nov 2020 11:29:32 GMT

Hi all,

I would like to sum a set of values within a list using Arcade. My experience of using Arcade is none. I have tried reading the introductions to Arcade etc but they aren't quite helping me.

In the screenshot example below, I would like to sum the "Total GCN found bottle trapping" {SumBT_GCN} across Waterbody 1, 2 and 3. So in this case, it would equal (9 + 6 + 0 = 15). I would also like to sum the torching, netting and refugia searching values too. My dashboard has some pie charts which successfully do this for me, but I really need to be able to present the sum of all the GCN for each survey type across all 3 waterbodies in a text format. Ideally so that I can use it to look at which is the highest value. This will then allow me to identify the maximum count of GCN found in any survey type and in any visit.

Here is a screenshot of the pie charts that are working fine.

I have attached the CSV of the layer I am using to populate my dashboard if it helps.

Thanks all,

Ben

topic Sum values within a dashboard list using arcade in ArcGIS Dashboards Questions

Sum values within a dashboard list using arcade