Dashboard Indicator box

[AmandaHutsel2]

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)

[KenBuja · Accepted solution]

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.