nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Dashboard-Arcade Expressions (Math)

MarlaJohnson

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 .

Find more posts tagged with

Accepted answers

jcarlson

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

All comments

MarlaJohnson

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;

jcarlson

Can you share the expression?

MarlaJohnson

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.

jcarlson

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.