Hello acarmody,
Sorry to hear you're experiencing issues.
Date is a reserved keyword in SQL and should not be used as a field name. However, that isn't what is causing this to fail.
The problem is that `t` in your script is a number (indicating the number of milliseconds) which cannot be used to filter by a date. You should convert the value in milliseconds to a Date first, and then you can filter based on that date value.
The following script below should work. Notice that after t is calculated in milliseconds, it is converted to a Date, before being used in the Filter expression.
var fs = FeatureSetByPortalItem(
Portal("https://www.arcgis.com"),
"[feature_layer_id]",
0,
["CreationDate", "WeightKg"],
false
);
var DateDict = {'fields': [{ 'name': 'Date', 'type': 'esriFieldTypeDate'},
{'name': 'Weight', 'type': 'esriFieldTypeDouble'}],
'geometryType': '', 'features': []};
// start variable for unix calculation
var start = ToLocal(Date(1970, 0, 01, 0, 0, 0, 0))
// variable for today, used to filtered averages < today
var t = DateDiff(Date(Year(today()),Month(today()),Day(today()),0,0,0,0),start, 'milliseconds')
t = Date(t)
console(t)
for (var f in fs){
var new_f = {'attributes':{'Date':DateDiff(
Date(Year(f['CreationDate']),
Month(f['CreationDate']),
Day(f['CreationDate']),
0,
0,
0,
0)
,start, 'milliseconds'),
'Weight':f['WeightKg']}}
Push(DateDict.features, new_f)}
var fs_gb = GroupBy(featureset(text(DateDict)), "Date", { name: 'TodayWeightSum', expression: 'Weight', statistic: 'SUM' });
console(count(fs_gb))
console(t);
var g = filter(fs_gb, "Date = @t")
for(var mm in g) {
return mm.TodayWeightSum
}
return "No results"
Thanks,
Taylor
