Dashboard Indicator box

AmandaHutsel2 — Thu, 28 Dec 2023 20:31:52 GMT

I'm trying to create a box showing the days remaining for our inspections. The variables are not working, specifically the filter and average.

var TotalPoles = $datapoint.count_OBJECTID_12_13;

var TotalHours = $reference.sum_hours_worked;

var PolesInspected = Filter(TotalPoles, 'inspection_type is NOT NULL')

var PolesRemaining = Filter(TotalPoles, 'inspection_type is NULL')

var PolesPerHour = PolesInspected/TotalHours

var AverageHours = Average(TotalHours, 'hours_worked');

var DaysLeft = PolesRemaining/(PolesPerHour*AverageHours)

Re: Dashboard Indicator box

KenBuja — Tue, 02 Jan 2024 16:39:41 GMT

The problem that you're running into is the Filter function requires a FeatureSet, but you're providing it with a value ($datapoint.count_OBJECTID_12_13). That's the same issue you're having with the Average function.

topic Re: Dashboard Indicator box in ArcGIS Online Developers Questions

Dashboard Indicator box

Re: Dashboard Indicator box