In this example, I excluded records with nulls in the user or date field from the input data, see line 6:
layer = Filter(layer, `${name} IS NOT NULL AND ${datetime} IS NOT NULL`)
As this problem is all about working with dates, we have to exclude null values in the date field. But it could be interesting to know about null values in the user field. For that, we have to change the filter inside the function according to whether the user argument is null or not:
function specific(fs, user) {
var sql = `${datetime} IS NOT NULL AND ${name} = @user`
if(user == null) {
sql = `${datetime} IS NOT NULL AND ${name} IS NULL`
}
var fs = Filter(fs, sql)
var extract_date_string = `CONCAT(EXTRACT(YEAR FROM ${datetime}), '-', EXTRACT(MONTH FROM ${datetime}), '-', EXTRACT(DAY FROM ${datetime}))`
var grouped_by_date = GroupBy(fs,
[{name: "DateString", expression: extract_date_string}],
[{name: "Count", expression: "1", statistic: "COUNT"}])
var edits = Sum(grouped_by_date, "Count")
var days = Count(grouped_by_date)
//return edits / days
return {edits: edits, days: days, mean: edits/days}
}
If you use the editor tracking fields for this, you won't get any meaningful results, because when the user field is empty, the date field will obviously be empty, too.
Have a great day!
Johannes
