topic Re: Calculating Difference Between Two Dates using Arcade Expressions in ArcGIS Dashboards Questions

Calculating Difference Between Two Dates using Arcade Expressions

BNix_TPA — Tue, 21 May 2024 17:47:31 GMT

I'm trying to add a new variable to my data set that is the difference between two dates, End and Start Date. I plan on using it in an indicator to show average time to close a WO. I created a new Arcade expression, but am receiving an error with it. Maybe there is a between way to achieve this than using an Arcade Expression. I was able to add this data to the pop-ups, but am having trouble recreating within the dashboard.

Re: Calculating Difference Between Two Dates using Arcade Expressions

KenBuja — Tue, 21 May 2024 18:33:15 GMT

If you trying to calculate the average for all the records in the FeatureSet, you'll have to loop through the collection to get that average.

Re: Calculating Difference Between Two Dates using Arcade Expressions

BNix_TPA — Wed, 22 May 2024 13:53:34 GMT

I don't really need the average calculated for all of the data since I can do this within the indicator itself. I just want to add a field showing the hours to close to the data within the dashboard so I can display this in the indicator. I still want the ability to filter based on other fields in the data too after this field is calculated.

Re: Calculating Difference Between Two Dates using Arcade Expressions

KenBuja — Wed, 22 May 2024 19:30:06 GMT

This will create a FeatureSet that contains the DateDiff calculation for each record.

var fs = FeatureSetByPortalItem( portal, 9437842bc29b54b07993a9b6b3d63c0d1 0, ['*'], //or use the only the fields you want to include false ); var s = Schema(fs); //return s Push(s.fields, {'name':'CloseTime', 'alias': 'Close Time', 'type': 'esriFieldTypeDouble'}) var temp_dict = { fields: s['fields'], geometryType: '', features: [] } for (var f in fs) { console(f) var attrs = {} for (var attr in f) { attrs[attr] = Iif(TypeOf(f[attr]) == 'Date', Number(f[attr]), f[attr]) } console(attrs) attrs['CloseTime'] = DateDiff(f.DateWoClosed, f.InitiateDate, 'hours') Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(Text(temp_dict))

Re: Calculating Difference Between Two Dates using Arcade Expressions

BNix_TPA — Thu, 23 May 2024 13:07:39 GMT

Thank you Ken. I inputted this into the data expression and received an initial error. I updated the beginning of the code to look like below, but I'm still receiving an error saying unable to execute.

var p = Portal("https://arcgis.com"); var fs = FeatureSetByPortalItem( p, "9437842bc29b54b07993a9b6b3d63c0d1", 0, ['*'], //or use the only the fields you want to include false );

Re: Calculating Difference Between Two Dates using Arcade Expressions

KenBuja — Thu, 23 May 2024 13:15:09 GMT

Make sure you have the correct item ID. When I try to open it, I get the message "The item you requested cannot be found. The item may have been deleted or you may have entered an incorrect URL."

Re: Calculating Difference Between Two Dates using Arcade Expressions

BNix_TPA — Fri, 24 May 2024 16:01:34 GMT

Thank you so much for your help! This worked. I realized the issues I was having was due to the item ID and I had the wrong sublayer. I'm pulling in a feature service from Cityworks and assumed it was sublayer 0, but it was actually 2. But it works perfectly, thank you!

Re: Calculating Difference Between Two Dates using Arcade Expressions

BNix_TPA — Thu, 24 Oct 2024 18:44:31 GMT

Hello again, thank you for you help on this. I'm trying to do a similar thing again as this, but this time I want to calculate the difference between two numbers instead of dates. Do you know how to alter this code to make that work?