Use Arcade to show maximum/min/avg for more than one record?

RandyMcGregor3

I need to show minimum and maximum values for a series of measurements associated with unique location.

I thought "max" and "min" would do the trick, but for both lists and indicators, I am only getting a result for each record. 

Both the list and the indicator are filtered and should have a discreet number of records that I would like to get statistics for.

Is it possible to do this? I have a bad feeling that I am overlooking something obvious 😞

Thank you for your time,

Randy McGregor

jcarlson

So if we had a data expression that grouped the records per-location, that could be enough? Try something like this, then set the indicator to Features. This should give you the three statistics for a given location. It won't aggregate across multiple locations, though, if that's an issue.

var fs = FeatureSetByPortalItem(
    Portal('url'),
    'itemID',
    1, // or whatever layer index this table is at. I'm assuming it's a related table?
    ['measurement-field', 'location-id'],
    false
)

return GroupBy(
    fs,
    'location-id',
    [
        {
            name: 'minimum',
            expression: 'measurement-field',
            statistic: 'MIN'
        },
        {
            name: 'maximum',
            expression: 'measurement-field',
            statistic: 'MAX'
        },
        {
            name: 'average',
            expression: 'measurement-field',
            statistic: 'AVG'
        }
    ]
)