topic Re: Dashboard data Expression returns null featureset in ArcGIS Dashboards Questions

Dashboard data Expression returns null featureset

SamBelisleLID1990 — Thu, 12 Jun 2025 19:25:28 GMT

I am trying to create a dashboard gauge to show percentage of time passed in a season. So, if the season runs from 1 July to 30 September, then on 23 July, the gauge should read 25%.

I want the FeatureSet to show the percentage in the 'DayPercentage' field for the gauge.

My Arcade code to do so is as follows:

var ThisYear = Number(Year(Now())); //var ThisMonth = Month(Now()); //var ThisDay = Day(Now()) var startDate = Number(Date(ThisYear,7,1)); var endDate = Number(Date(ThisYear,9,30)); var currentDate = Number(Date(ThisYear, 7, 25)); var Season = Number(DateDiff(endDate,startDate)) var SeasonSoFar = Number(DateDiff(currentDate,startDate)) var SeasonPerc = Number((SeasonSoFar/Season)*100); var features = []; Push(features, SeasonPerc) var PercDict = { 'fields': [ {'name':'DayPercentage','type':'esriFieldTypeInteger'} ], 'features': features }; var features2 = FeatureSet(PercDict); return features2

This returns a null dataset. I've tried formatting the Dictionary differently, formatting the FeatureSet differently, using Push to get the data through in different places and formats, and I'm stuck. What am I doing wrong?

Re: Dashboard data Expression returns null featureset

KenBuja — Thu, 12 Jun 2025 19:58:59 GMT

There were a couple of things that needed changing.

The dates are incorrect if you're portraying 1 July through 30 Sept. In the Date function, months are 0-based, so July is 6, not 7 (lines 5, 6, and 7)
The SeasonPerc was a NaN since you were converting the Dates to numbers (lines 5, 6, and 7). The DateDiff function needs Dates as input, not the converted number.
DateDiff also returns a number, so there's no need to convert it (lines 9 and 10)
SeasonPerc has to be an integer if you're putting it into a integer field (line 11). If it's not converted (and Arcade will not convert it for you), that field attribute will be null.
You have to push a dictionary object containing the "attributes" key into the features array (line 15)

Re: Dashboard data Expression returns null featureset

SamBelisleLID1990 — Thu, 12 Jun 2025 20:33:41 GMT

Thank you so much!

Many of those changes were things I had actually done correctly the first time but had changed in all my attempts to fix this. The push with attributes was the missing piece.

Re: Dashboard data Expression returns null featureset

KenBuja — Fri, 13 Jun 2025 11:19:11 GMT

Glad to help. Please check the "Accept as Solution" box to help others searching on this problem