nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I find the max value of all features?

TysonM

I thought Arcade was supported by all ESRI products, but I can't use the $layer prefiix to find the max value across all records in my layer.

In ArcGIS Online, it's very easy to do, but Pro does not recognize $layer at all. Why doesn't Arcade for Pro work like the online version?

Najděte více příspěvků označených jako

Accepted answers

XanderBakker

Hi Tyson TM ,

When you calculate a field in ArcGIS Pro you have access to the FeatureSetBy* functions which you can use to access the featureset and use it in the Min and Max functions of Arcade.

Before:

After:

Arcade expression:

<SPAN class="keyword token">var</SPAN> fs <SPAN class="operator token">=</SPAN> <SPAN class="token function">FeatureSetByName</SPAN><SPAN class="punctuation token">(</SPAN>$datastore<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"BojacaRNI_puntos"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> <SPAN class="number token">1</SPAN><SPAN class="operator token">/</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">MAX</SPAN><SPAN class="punctuation token">(</SPAN>fs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CampoEM"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="token function">MIN</SPAN><SPAN class="punctuation token">(</SPAN>fs<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CampoEM"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

You can use either $datastore with the name of the featureclass or $map with the name in the TOC. Remember that the Min and Max functions take two parameters (the featureset and the fieldname).

All comments

DanPatterson

Not all is applicable to all products yet.

Getting Started | ArcGIS for Developers

Arcade Function Reference | ArcGIS for Developers

JoshuaBixby

Can you elaborate on how exactly you are trying to use Arcade in Pro? What part of Pro (Field Calculator, Labeling, etc...) are you trying your code?

TysonM

I'm using the Calendar Heat Map Chart to track events that have occurred over a 20 year span. Currently the chart aggregates all of the events by day of the year. Instead of counting each event a whole unit, I need to average it by year.

I attempted to create a calculated field that would hold a value that is the inverse of the number of years, to effectively get a per year average. My plan was to simply have Arcade take the difference between the MAX and MIN year value, and divide 1 by it. E.G. 1/ (MAX($layer.Year)-MIN($layer.Year)). I could then use this field in the Calendar Heat Map to average out the events per day.

Since the events range from early 2000 to present day, I need to calculate the MAX and MIN down the entire table, not just by row/record/feature, which is how Arcade works in Pro. There is no $layer option like there is in the Online version. Now, I can certainly just enter in .05 and call it good. But I don't want to have to update this every year.