topic Re: Hours Spent in ArcGIS Dashboards Questions

Hours Spent

aprhyde11 — Mon, 27 Mar 2023 18:11:08 GMT

I'm trying to display the total hours spent on a project per day per team. I'm new to arcade so everything I've found hasn't quite worked for what I need.

The only time carrying attribute that I have is the date with time. From my research I've been finding that I need a separate time attribute?

Is there anyway that I can show this data?

If you need more info please let me know

Re: Hours Spent

jcarlson — Mon, 27 Mar 2023 20:05:29 GMT

To show a duration, you need a start and end time, which you'd be able to feed into the DateDiff function to get the hours.

DateDiff($datapoint['end_time'], $datapoint['start_time'], 'hours')

Re: Hours Spent

aprhyde11 — Tue, 28 Mar 2023 19:36:26 GMT

I have added start and end times but still can't seem to get the difference to display. Do you have any more suggestions?

Re: Hours Spent

jcarlson — Tue, 28 Mar 2023 19:37:57 GMT

What does your expression look like? Hard to say why it's not displaying without seeing what's actually happening.

Re: Hours Spent

aprhyde11 — Tue, 28 Mar 2023 20:01:19 GMT

This is what it looks like. I'm trying to create an Indicator on a dashboard. The indicator says "Unable to execute Arcade script"

var startDate = Date($datapoint.timestart);
var endDate = Date($datapoint.timeend);
var age = DateDiff(endDate, startDate, 'hours');

return {
  //textColor:'',
  //backgroundColor:'',
  //topText: '',
  //topTextColor: '',
  //topTextOutlineColor: '',
  //topTextMaxSize: 'medium',
  middleText: age,
  middleTextColor: '',
  middleTextOutlineColor: '',
  middleTextMaxSize: 'large',
  //bottomText: '',
  //bottomTextColor: '',
  //bottomTextOutlineColor: '',
  //bottomTextMaxSize: 'medium',
  //iconName:'',
  //iconAlign:'left',
  //iconColor:'',
  //iconOutlineColor:'',
  //noValue:false,
  //attributes: {
    // attribute1: '',
    // attribute2: ''
  // }
}

Re: Hours Spent

jcarlson — Tue, 28 Mar 2023 20:12:23 GMT

Are your fields actually dates? If so, you don't need to use the Date function.

PS - You may want to use Round or Text to format the output nicely.

Re: Hours Spent

aprhyde11 — Tue, 28 Mar 2023 20:45:11 GMT

Yes the time fields include the date and time. I'm using the start and end functions built in to survey123.

Unfortunately, it still isn't working for me 😭

Thank you so much for your help though!

Re: Hours Spent

jcarlson — Tue, 28 Mar 2023 20:48:08 GMT

Can you just confirm that it's a true DateTime field, and not text? I've had surveys store other datatypes as text in the past.

Re: Hours Spent

aprhyde11 — Tue, 28 Mar 2023 20:57:33 GMT

It is by date