Indicator Arcade Assistance

GaryMorris

I am creating a Dashboard displaying data from my city's permits.  I have text fields of the application date and the issued date.  I am trying to cast them into date fields and then get the average days that it took to issue the permit.  When I run the script that I have so far, I get an error:  Test execution error: Execution error - Invalid parameter. Verify test data.

 

Here is the script I have so far:

var portal_ = Portal('https://arcgis.com');

var fs = FeatureSetByPortalItem(portal_,

 'Item ID', 0,['*'], false);

for (var f in fs) {

    var date_Applied = f["Applied_Date"];

    var date_Issued = f['Issued_Date'];

    var startDate = DateOnly(date_Applied);

    var endDate = DateOnly(date_Issued);

    var differences = DateDiff(startDate, endDate, 'days');

    var total = Sum(differences);

    var totalrows = Count(differences);

    var avg = total/totalrows;}

    return avg

 

 

Any help is greatly appreciated.

 

kenbuja

This has some more error checking in it (making sure the dates aren't null and has three numbers separated by "/"). I also fixed an error in line 26 that used the wrong variable name. And I reversed the dates in the line 17.

function StringToDate(input) {
  if (IsEmpty(input)) return null;
  var arr = Split(input, "/");
  if (Count(arr) != 3) return null;
  for (var i of arr) {
    if (IsNan(Number(i))) return null;
  }
  var theDate = DateOnly(arr[2], arr[0] - 1, arr[1]);
  iif(IsNan(theDate), null, theDate);
}
var total;

for (var f in fs) {
  var date_Applied = StringToDate(f["Applied_Date"]);
  var date_Issued = StringToDate(f["Issued_Date"]);
  if (IsEmpty(date_Applied) || IsEmpty(date_Issued)) continue;
  var differences = DateDiff(date_Issued, date_Applied, "days");
  total += Sum(differences);
}
var totalrows = Count(fs);
var avg = iif(totalrows == 0, 0, Floor(total / totalrows));

return FeatureSet(
  {
    fields: [{ name: "Average", type: "esriFieldTypeInteger" }],
    features: [{ attributes: { Average: avg } }]
  }
);