topic Re: Arcade issue within dashboard in ArcGIS Dashboards Questions

Arcade issue within dashboard

MicBry — Tue, 30 Sep 2025 12:55:32 GMT

Hi!

I have an issue connected to my dashboard and its widgets. I am currently using enterprise 11.3. In short, my dashboard uses a category selector and an indicator. The widgets have different data, but are connected through similar fields.

My indicator uses a datapoint and a redference value. Both use the same data source, however they are filtered in different ways. My first value (datapoint) shows land (m2) that our municipal landlort taker care of. The seconf value shows land that the residents themselves takes care of. The third value is a grouping of the other to. In short:

Datapoint = Area m2

Reference value = other areas m2

Own value = Area + other areas m2

So, to the issue. I have certain areas where the reference value is non existent, i.e. areas where no land is to be taken care of by the residents. This makes the arcade script fail behind the scenes. The indicator returns no data even when an area containt datapoint but not reference value.I would like the reference value to be treated as 0 so that i always get a result.

Down below is a basic interpretation of my script:

var allmannaytor = $datapoint["sum_SHAPE.STArea()"]

var hyresgastskottaytor = $reference["sum_SHAPE.STArea()"]

var total = allmannaytor + hyresgastskottaytor

return {

//textColor:'',

//backgroundColor:'',

topText: 'Allmänna ytor: ' + Text(Round(allmannaytor, 0), "#,###") + ' m²',

topTextColor: '',

topTextOutlineColor: '',

topTextMaxSize: 'medium',

middleText: 'Hyresgästskötta ytor: ' + Text(Round(hyresgastskottaytor, 0), "#,###") + ' m²',

middleTextColor: '',

middleTextOutlineColor: '',

middleTextMaxSize: 'medium',

bottomText: 'Totala ytor: ' + Text(Round(total, 0), "#,###") + ' m²',

bottomTextColor: '',

bottomTextOutlineColor: '',

bottomTextMaxSize: 'x-small',

//iconName:'',

//iconAlign:'left',

//iconColor:'',

//iconOutlineColor:'',

//noValue:false,

//attributes: {

// attribute1: '',

// attribute2: ''

// }

}

I have tried to adjust this script adding if-statements, isempty and so on. Nothing is working for me. I need something that tells the dashboard to check for reference value first. If the value is non existing (not 0) it needs to be interpreted as 0. If a value exists this function can be ignored.

Any suggestions?

Re: Arcade issue within dashboard

AustinAverill — Tue, 30 Sep 2025 17:23:33 GMT

Since your `total` variable, and the rich text you are constructing at the end both reference this possibly invalid value, you are likely running into issues of referencing an unassigned variable at some point if you try to bypass that single variable.

Instead, your if statement should look something like below. I have also made the variable assignment as the entire string that you are inserting into your values later. So you would need to change that portion to reflect that if you wanted to use this.

if(isEmpty($reference["sum_SHAPE.STArea()"]) || isNan($reference["sum_SHAPE.STArea()"])){ var hyresgastskottaytor = 'No Available Data' var allmannaytor = 'Allmänna ytor: ' + Text(Round($datapoint["sum_SHAPE.STArea()"], 0), "#,###") + ' m²' var total = 'Totala ytor: ' + Text(Round($reference["sum_SHAPE.STArea()"] + $datapoint["sum_SHAPE.STArea()"], 0), "#,###") + ' m²' }else{ var hyresgastskottaytor = 'Hyresgästskötta ytor: ' + Text(Round($reference["sum_SHAPE.STArea()"], 0), "#,###") + ' m²' var allmannaytor = 'Allmänna ytor: ' + Text(Round($datapoint["sum_SHAPE.STArea()"], 0), "#,###") + ' m²' var total = 'Totala ytor: ' + Text(Round($reference["sum_SHAPE.STArea()"], 0), "#,###") + ' m²' }

Re: Arcade issue within dashboard

Neal_t_k — Tue, 30 Sep 2025 17:32:22 GMT

Would something like this work?

var hyresgastskottaytor = $reference["sum_SHAPE.STArea()"] var hyresgastskottaytor_fix = iif(hyresgastskottaytor == '',0, hyresgastskottaytor) var total = allmannaytor + hyresgastskottaytor_fix

https://community.esri.com/t5/arcgis-dashboards-questions/create-an-if-or-iif-statement-for-details-or-list/td-p/1146476

Re: Arcade issue within dashboard

AustinAverill — Tue, 30 Sep 2025 17:40:21 GMT

This would not work since you are checking to see if a numeric value is an empty string. This condition will always evaluate to the field value. You would need to use:

var hyresgastskottaytor_fix = iif(isEmpty(hyresgastskottaytor) || isNan(hyresgastskottaytor),0, hyresgastskottaytor)

If for some reason your data set has empty strings, you could add an additional condition to evaluate for ''. But it shouldn't be necessary.

Re: Arcade issue within dashboard

MicBry — Wed, 01 Oct 2025 05:19:11 GMT

Hi!

Thank you so much for reaching out. It didn't work but i appriciate you trying.

Best, Michaela

Re: Arcade issue within dashboard

MicBry — Wed, 01 Oct 2025 05:22:15 GMT

Hi!

I changed the script to this:

var hyresgastskottaytor = $reference["sum_SHAPE.STArea()"]

var hyresgastskottaytor_fix = iif(isEmpty(hyresgastskottaytor) || isNan(hyresgastskottaytor),0, hyresgastskottaytor)

var allmannaytor = $datapoint["sum_SHAPE.STArea()"]

var total = allmannaytor + hyresgastskottaytor_fix

return {

//textColor:'',

//backgroundColor:'',

topText: 'Allmänna ytor: ' + Text(Round(allmannaytor, 0), "#,###") + ' m²',

topTextColor: '',

topTextOutlineColor: '',

topTextMaxSize: 'medium',

middleText: 'Hyresgästskötta ytor: ' + Text(Round(hyresgastskottaytor_fix, 0), "#,###") + ' m²',

middleTextColor: '',

middleTextOutlineColor: '',

middleTextMaxSize: 'medium',

bottomText: 'Totala ytor: ' + Text(Round(total, 0), "#,###") + ' m²',

bottomTextColor: '',

bottomTextOutlineColor: '',

bottomTextMaxSize: 'x-small',

//iconName:'',

//iconAlign:'left',

//iconColor:'',

//iconOutlineColor:'',

//noValue:false,

//attributes: {

// attribute1: '',

// attribute2: ''

// }

}

I'm getting the same result. Did i missunderstand your suggestion? Thank you so much for taking the time to answer me, appriciate it!

Best, Michaela

Re: Arcade issue within dashboard

AustinAverill — Wed, 01 Oct 2025 10:21:45 GMT

If that is producing an error at that data point specifically, I would recommend looking at the value in that field specifically. If it is null or nan, it should be evaluating to zero and function as intended. If the value is something other than these two, you would need to add additional logic to handle the data.

Re: Arcade issue within dashboard

MicBry — Wed, 01 Oct 2025 11:39:03 GMT

Hi!

The issue is that i have neither 0 nor null. The referencepoint does not exist for certain selections. I would like to check if the referencevalue exists, not what it contains. I'm not great with arcade so maybe that is what your script was supposed to check(?).

Best,

Michaela

Re: Arcade issue within dashboard

Neal_t_k — Wed, 01 Oct 2025 13:20:21 GMT

@MicBry couldn't hurt to try this:

var hyresgastskottaytor_fix = iif(isEmpty(hyresgastskottaytor) || isNan(hyresgastskottaytor || hyresgastskottaytor==''),0, hyresgastskottaytor)

could also try:

var hyresgastskottaytor_fix = DefaultValue(hyresgastskottaytor, 0)

Re: Arcade issue within dashboard

MicBry — Wed, 01 Oct 2025 13:36:46 GMT

Thanks again Neal!

The first one made the script fail. The second one worked but the issue with no data remained. Thanks though!!

Re: Arcade issue within dashboard

AustinAverill — Wed, 01 Oct 2025 14:36:55 GMT

Got it! In this case it sounds like we are checking whether the profile variable `$reference` has been defined with a feature/data.

I am not sure if this will work since $reference is not being defined... But you could try:

if(HasKey($reference, 'sum_SHAPE.STArea()')){ var hyresgastskottaytor = $reference["sum_SHAPE.STArea()"] }else{ var hyresgastskottaytor = 0 } var hyresgastskottaytor_fix = iif(isEmpty(hyresgastskottaytor) || isNan(hyresgastskottaytor),0, hyresgastskottaytor) var allmannaytor = $datapoint["sum_SHAPE.STArea()"] var total = allmannaytor + hyresgastskottaytor_fix

Re: Arcade issue within dashboard

Neal_t_k — Wed, 01 Oct 2025 20:15:30 GMT

@MicBry I am not sure this can be done in this manner. I don't think the indicator even gets to the calculation part in the advanced editor, If either the datapoint or the reference can't be evaluated, the indicator defaults to 'No Data'. I ran a couple tests, hard coded a variable in place of the reference, and as soon as I filtered the data to something that the reference couldn't evaluate, the indicator went to no data, even though the advanced editor should have evaluated correctly.

Re: Arcade issue within dashboard

MicBry — Thu, 02 Oct 2025 06:21:59 GMT

Hi again Neal!

That's my thought as well.. I've run so many test by now and it doesn't seem like it wants to accept any solution if the referencepoint can be seen as non existant. It's unfortionaty, but i'm happy to see that we both reached the same conclusion. Thanks again for taking the time to look further into this for me. Really appriciate it!

/Michaela

Re: Arcade issue within dashboard

Neal_t_k — Thu, 02 Oct 2025 13:05:55 GMT

@MicBry Maybe a new data expression like this would be the direction to go. It makes a new feature set with the original "sum" and then the new column is zeroed out if it meets the criteria, otherwise it is the sum. You can then build the indicator in the same manner but using the expression as the source.

you would just have to make sure you include the proper fields for your filter/queries.