topic Re: How to use DateDiff function with custom dates in Dashboard in ArcGIS Dashboards Questions

How to use DateDiff function with custom dates in Dashboard

wAlexPage — Tue, 13 Jun 2023 19:34:48 GMT

I'm building an indicator in dashboard. What I would like to show is the current velocity & the velocity required to finish by year end in 'mi'.

I've got the current velocity working, sort of. In order to keep that working and get the the second velocity working I need DateDiff to work with manually entered dates. All the examples I see link it to date fields in the feature using $feature, but for this purpose those dates are irrelevant.

The 138 is my remaining working days and that is currently manually entered, thus I need the var age to generate this number instead. (var remainingDays = 138) You can see father down (age) is showing the NaN in topText:

I my project started 3-27-23 and times out 12-31-23. I'm wondering if the problem is the output format of the Date vs Day(Now()).

See screenshot for context.

var endDate = Date('12/31/2023','MM/DD/YYYY')
var startDate = Day(Now())
var age = DateDiff(endDate, startDate,'days')

var remainingDays = 138
var totalProduction = $datapoint["sum_Miles"]  // Actual total production to date
var totalDays = 192  // The actual total number of days avalible

var projectedVelocity = totalProduction / (totalDays - remainingDays)

return {
    //textColor:'',
    //backgroundColor:'',
    topText: (age),
    //topTextColor: '',
    //topTextOutlineColor: '',
    //topTextMaxSize: 'medium',
    middleText: Round (projectedVelocity,3)+"mi",

Re: How to use DateDiff function with custom dates in Dashboard

JohannesLindner — Wed, 14 Jun 2023 07:40:56 GMT

Your startDate isn't a date, because you're extracting the current day...

You can also use Today() instead of Now() to get full days.

var endDate = Date('12/31/2023','MM/DD/YYYY') var startDate = Today() var age = DateDiff(endDate, startDate,'days')

Re: How to use DateDiff function with custom dates in Dashboard

wAlexPage — Wed, 14 Jun 2023 14:10:18 GMT

Thank you very much for your assistance! I wanted to take a few and clean up the expression for everyone to benefit from. it worked beautifully.

I got rid a place where it was duplicating one of the variables and swapped out one of the others to subtract 'nonWorkDays' giving us more control over how many days were actually available.

Thank you again @JohannesLindner !

Alex

Re: How to use DateDiff function with custom dates in Dashboard

wAlexPage — Wed, 14 Jun 2023 21:17:01 GMT

Here's what I was doing with it.

//var Days from start to date

var endDate = Today()

var startDate = Date('03/27/2023','MM/DD/YYYY')

var ytdDays = DateDiff(endDate, startDate,'days')

// Actual total production to date

var totalProduction = $Datapoint["sum_Miles"]

// The actual total number of days avalible

var nonWorkDays = 22

var actualVelocity =

totalProduction / (ytdDays - nonWorkDays)

return actualVelocity

//Good Luck

Re: How to use DateDiff function with custom dates in Dashboard

AndyMinor2 — Fri, 16 Jun 2023 00:14:09 GMT

Hey Alex,

I am trying to do something similar to this. I am trying to determine the Age of an item based on the Date difference from Today to a Date in an attribute field. I would like this to work as either an Indicator or a Gauge. I appreciate any help you can provide.

Thanks,

Andy

//var Days from start to date

var endDate = Today()

var startDate = $datapoint.PurDate

var age = DateDiff(endDate, startDate,'days')

return age

Re: How to use DateDiff function with custom dates in Dashboard

AlexPage — Fri, 16 Jun 2023 04:41:01 GMT

Hey Andy,

I think we don't have enough information to help here. If this is for a Dashboard, the first thing I'd mention is the gauge won't have the access to Arcade that indicator does.

The next thing is if you look back at my expression the primary data I'm pulling is sum_Miles, this is a virtual item being compiled by the indicator on the Data tab. I don't have a feature called this, it's from telling the indicator to sum the miles field.

I don't believe you can pull something else (CreationDate) from $datapoint if it's already being used. You said you want to tell the age of something with an indicator, but yours is likely like mine in that this supports some other expresion.

What is that? Is something else already using $datapoint? I've been playing with mine for a while now and I'm still stuck.

This isn't saying much though because I'm very new to all this, about a year in. I'll be back at the desk in the morning. G'night, Alex

Re: How to use DateDiff function with custom dates in Dashboard

AndyMinor2 — Fri, 16 Jun 2023 23:42:08 GMT

Alex,

Sorry. Yes, a Dashboard. I was trying to use your Arcade expression since it does something similar to what I am trying to do. I am trying to make an Indicator that tracks how old my chickens are for butchering. I have an attribute field for the date the chicks hatched and want to keep track of their age and butcher around 8-10 weeks old. Then I will log the data using my QuickCapture app and see the weight, cost and dates for tracking production. I was hoping to use a Gauge to act like a fuel gauge and reach full when they are done.

I tried creating the date variables and pulling the date field from the $datapoint but didn't have any luck. I'm still trying to learn Arcade. Thanks for the help.

Andy

Re: How to use DateDiff function with custom dates in Dashboard

AlexPage — Sat, 17 Jun 2023 00:53:23 GMT

Andy,

I love this, I want to see you achieve this! We'll pick up next week. I grew up in the country and we did broilers too.

Alex

Re: How to use DateDiff function with custom dates in Dashboard

AndyMinor2 — Sat, 17 Jun 2023 01:19:52 GMT

Here's my QC app.

Re: How to use DateDiff function with custom dates in Dashboard

AlexPage — Tue, 20 Jun 2023 15:54:59 GMT

Wanted to bring this one home for everyone here.

To complete the indicators I needed to exclude the company holidays and weekends. This was being achieved through a manual entry above, but I wanted it scripted.

I worked with one of great folks at Esri, Paul Barker who gave me a direction to go, then took what I made and actually made it work. I was using normal dates, not starting at month 0, and attempting a for loop, but his 'while' statement looks so great, and is easier to get my head around.

What it does: Divides production / working days, by removing non-working days to create project velocity, and shows you the remaining days to the deadline. To create the actual velocity, just flip flip the initial variables.

// array of holiday dates (note Month is a zero indexed value) var holiDates = [ Date(2023, 0, 2), Date(2023, 3, 7), Date(2023, 4, 29), Date(2023, 6, 4), Date(2023, 10, 23), Date(2023, 10, 24), Date(2023, 11, 25), Date(2023, 11, 26) ]; //set up initial variables var todayDate = Today(); var counter = 0; var endDate = Date(2023, 6, 15); // End date of project //iterate over the range and count the work days while (todayDate <= endDate) { var currWeekDay = Weekday(todayDate); var isWorkDay = currWeekDay > 0 && currWeekDay < 6; var isHoliday = Includes(holiDates, todayDate); // check that its a work day and not a holiday and if so count it if (isWorkDay && !isHoliday) { counter += 1; } todayDate = DateAdd(todayDate, 1, "days"); } // Starting total project miles var startMiles = 112.3 // Actual total production to date var ytdProduction = $Datapoint["sum_Miles"] var requiredVelocity = (startMiles - ytdProduction) / counter; return { //textColor:'', //backgroundColor:'', topText: (counter)+" "+"Work Days Remain", topTextColor: 'red', topTextOutlineColor: 'red', topTextMaxSize: 'medium', middleText: Round (requiredVelocity,3)+"mi", middleTextColor: 'orange', middleTextOutlineColor: 'red', middleTextMaxSize: 'medium', //bottomText: '', //bottomTextColor: '', //bottomTextOutlineColor: '', //bottomTextMaxSize: 'small', //iconName:'', iconAlign:'left', iconColor:'Orange', iconOutlineColor:'red', //noValue:false, //attributes: { // attribute1: '', // attribute2: '' // } }

Thanks Paul!