topic Re: ArcGIS Dashboard-Arcade Expressions (Math) in ArcGIS Dashboards Questions

ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Tue, 09 May 2023 15:30:45 GMT

Can you use data expressions in ArcGIS Dashboards to perform math with a pervious record? The data is stored in ArcGIS Server and pulled into ArcGIS Online .

Re: ArcGIS Dashboard-Arcade Expressions (Math)

jcarlson — Tue, 09 May 2023 17:51:08 GMT

Yes! Provided you can identify what "previous" means with some record sorting, etc., you can easily write an expression that uses the previous record's value to calculate something else.

Re: ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Tue, 09 May 2023 18:09:23 GMT

I am trying to subtract the current day number (chemical reading) from the previous day. It is usually the record right before if sorted by date The issue is Arcade expression is not calling the data, which makes me think I am doing it wrong.

Re: ArcGIS Dashboard-Arcade Expressions (Math)

jcarlson — Tue, 09 May 2023 18:10:38 GMT

Can you share the expression?

Re: ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Tue, 09 May 2023 18:21:23 GMT

I have tried a lot of different things. I do have an empty field I can place the results in. This is for a serial chart.

var portal = Portal('https://www.arcgis.com');
var fs = FeatureSetByPortalItem(portal, 'fcb8c011c9f44ad09e735683da808b41');

var currentIndex = feature['OBJECTID'];
var previousIndex = currentIndex - 1;

if (previousIndex > 0) {
var previousRecord = FeatureByIndex(fs, previousIndex);

var previousValue = previousRecord['INSPAnswerNumber'];
var currentValue = feature['INSPAnswerNumber'];

if (!IsEmpty(currentValue) && !IsEmpty(previousValue)) {
return currentValue - previousValue;
}
}

return null;

Re: ArcGIS Dashboard-Arcade Expressions (Math)

jcarlson — Tue, 09 May 2023 20:00:31 GMT

I'm not sure how you ended up with that expression. The FeatureSetByPortalItem function requires you to specify the layer index, and it won't get past the second line as its written. Even if it did, it needs to return a FeatureSet object.

The way Data Expressions work is a bit different from other Arcade profiles. If you haven't yet, take a look at some of the expressions here:

https://github.com/Esri/arcade-expressions/tree/master/dashboard_data

In particular, note how you need to first define a dictionary with the fields defined and an empty array for the features. Then you need to loop through every feature in your FeatureSet to push attributes to that dictionary. It will look very different from what you have posted.

var portal = Portal('https://www.arcgis.com'); var fs = FeatureSetByPortalItem( portal, 'fcb8c011c9f44ad09e735683da808b41', 0, ['some_field'], false ); var out_dict = { fields: [ {name: 'some_field', type: 'esriFieldTypeInteger'}, {name: 'difference_from_last', type: 'esriFieldTypeInteger'}], geometryType: '', features: [] } var prev_val = 0 for (var f in fs) { Push( out_dict['features'], { attributes: { some_field: f['some_field'], difference_from_last: f['some_field'] - prev_val } } ) prev_val = f['some_field'] } return FeatureSet(Text(out_dict))

Re: ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Tue, 09 May 2023 21:33:23 GMT

I updated it to this but not exactly getting the correct data back. One day someone puts in data, a number. The second day someone puts in data, a number. I need it to look at the second day and subtract it from the first day. It is easy in python.
var portal = Portal('https://www.arcgis.com');
var fs = FeatureSetByPortalItem(portal, 'fcb8c011c9f44ad09e735683da808b41', 0, ['INSPAnswerNumber'], false);

var out_dict = {
fields: [
{ name: 'INSPAnswerNumber', type: 'esriFieldTypeInteger' },
{ name: 'difference_from_last', type: 'esriFieldTypeInteger' }
],
geometryType: '',
features: []
};

var prev_val = 0;
for (var feature in fs) {
var current_val = feature['INSPAnswerNumber'];
Push(out_dict['features'], {
attributes: {
INSPAnswerNumber: current_val,
difference_from_last: current_val - prev_val
}
});
prev_val = current_val;
}

return FeatureSet(Text(out_dict));

Re: ArcGIS Dashboard-Arcade Expressions (Math)

jcarlson — Tue, 09 May 2023 21:37:57 GMT

Well, that can depend on the data itself. Is the field actually an integer, or does it need to be converted?

Are you records already in the appropriate order? You may need to use Sort if not.

What are you getting back, if anything?

Re: ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Tue, 09 May 2023 21:42:24 GMT

The data is an interger I am getting back weird numbers that make no sense.

Re: ArcGIS Dashboard-Arcade Expressions (Math)

jcarlson — Tue, 09 May 2023 21:46:33 GMT

Can you give some examples? It's hard to know how the expression is failing without knowing what it's actually doing.

Re: ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Wed, 10 May 2023 09:57:23 GMT

That is a good point. With he expression I sent I am getting these results. I am using this data in the second screenshot. So the difference form last makes no sense.
[cid:image001.png@01D98304.2A9B02D0]
[cid:image002.png@01D98304.2A9B02D0]

Re: ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson — Thu, 11 May 2023 21:52:27 GMT

I figured this out. Thanks for the help.