https://community.esri.com/t5/arcgis-pro-questions/arcade-calc-field-average-values-with-same/m-p/1327723#M72958 <P>For a field calculation, we're evaluating the expression per row of the table, and we only have to worry about matching values. By filtering the full layer based on the date field, you can easily get that subset, then use the Average function to get the numeric average of any field.</P><LI-CODE lang="javascript">var fs = $layer var matching_ts = Filter(fs, `date_field = ${$feature['date_field']}`) return average(matching_ts, 'numeric_field')</LI-CODE><P>Whether or not this works will depend on where the data is at, too. For some database providers, the timestamp needs to be wrapped in "timestamp '...'". Also, the variable $layer may not work there, so you may need to use a FeatureSet function to bring the rest of the layer's values in.</P> Tue, 12 Sep 2023 14:12:45 GMT jcarlson 2023-09-12T14:12:45Z https://community.esri.com/t5/arcgis-pro-questions/arcade-calc-field-average-values-with-same/m-p/1327681#M72953 <P>I am trying to mimic the Average field calculation in the below table, in Arcade.&nbsp; Anybody lend a hand?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ArmstKP_0-1694524437509.png" style="width: 571px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/80425i17AB65DEC7E51145/image-dimensions/571x230?v=v2" width="571" height="230" role="button" title="ArmstKP_0-1694524437509.png" alt="ArmstKP_0-1694524437509.png" /></span></P><P>&nbsp;</P> Tue, 12 Sep 2023 13:14:58 GMT https://community.esri.com/t5/arcgis-pro-questions/arcade-calc-field-average-values-with-same/m-p/1327681#M72953 ArmstKP 2023-09-12T13:14:58Z https://community.esri.com/t5/arcgis-pro-questions/arcade-calc-field-average-values-with-same/m-p/1327723#M72958 <P>For a field calculation, we're evaluating the expression per row of the table, and we only have to worry about matching values. By filtering the full layer based on the date field, you can easily get that subset, then use the Average function to get the numeric average of any field.</P><LI-CODE lang="javascript">var fs = $layer var matching_ts = Filter(fs, `date_field = ${$feature['date_field']}`) return average(matching_ts, 'numeric_field')</LI-CODE><P>Whether or not this works will depend on where the data is at, too. For some database providers, the timestamp needs to be wrapped in "timestamp '...'". Also, the variable $layer may not work there, so you may need to use a FeatureSet function to bring the rest of the layer's values in.</P> Tue, 12 Sep 2023 14:12:45 GMT https://community.esri.com/t5/arcgis-pro-questions/arcade-calc-field-average-values-with-same/m-p/1327723#M72958 jcarlson 2023-09-12T14:12:45Z