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; } } }

Hours Spent

aprhyde11

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

Find more posts tagged with

Accepted answers

jcarlson

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')

All comments

jcarlson

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')

aprhyde11

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

jcarlson

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

aprhyde11

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: ''
  // }
}

jcarlson

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.

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.