Arcade: Only Return Most Recent/Latest Record For Each Day?

ArmstKP

I have a hosted feature layer with multiple records per day for a feature.  How would I return only the most recent record per day?

Here is my code, but returns multiple records per day:

 

var mowhistory = Overlaps(FeatureSetByPortalItem(Portal('https://www.arcgis.com'),"00871a3866be4ceaa11f7841b43cf82a",0), $feature);

var mowhistorytimeSorted = Orderby(mowhistory, 'lastserviced DSC')

var popupString = "";

for (var myfeature in mowhistorytimeSorted){

    popupString += text(myfeature.lastserviced, 'MMM DD Y, hh:mm A') +

    TextFormatting.NewLine

}

return popupString

JustinReynolds

Here is an example that gives you both.  You won't need to change much.

You will need to change:

• $layer on line 2 to your FeatureSetByPortalItem
• service_date on line 2 to lastserviced
• .service_date on line 11 to .lastserviced
• .service_date on line 24 to .lastserviced

Decide whether you want firstFeature or lastFeature on line 22

 

// Sort ascending is important
var fset = OrderBy($layer, 'service_date ASC');

var currentDateGroup;
var _date;
var firstFeatures = [];
var lastFeatures = [];
var popupString;

for (var f in fset) {
  _date = Text(f.service_date, 'YMMDD');
  if (currentDateGroup != _date) {
    currentDateGroup = _date;
    Push(firstFeatures, f);
    Push(lastFeatures, f);
  } else {
    Pop(lastFeatures);
    Push(lastFeatures, f);
  };
};

var features = lastFeatures; // choose to use firstFeatures, or last features here
for (var fIdx in features) {
  popupString += Text(features[fIdx].service_date, 'MMM DD Y, hh:mm A') + TextFormatting.NewLine;
};
return popupString;

 

Output

 

Newest feature for each day based on datetime field (aka lastFeature)
Feb 28 2023, 05:01 PM
Mar 01 2023, 03:59 PM
Mar 02 2023, 05:03 PM
Mar 08 2023, 04:58 PM
Mar 10 2023, 08:51 AM

Oldest feature for each day based on datetime field(aka firstFeature)
Feb 28 2023, 01:13 PM
Mar 01 2023, 08:13 AM
Mar 02 2023, 10:09 AM
Mar 08 2023, 09:22 AM
Mar 10 2023, 07:36 AM