topic Re: Indicator to show start time, end time, and total time. in ArcGIS Online Developers Questions

Indicator to show start time, end time, and total time.

AmandaHutsel2 — Fri, 02 Feb 2024 20:13:29 GMT

I need help coding an indicator box to show some times. I would like it to look something like:

Start Time: <start time>

End Time: <end time>

Total Hours Worked: <hours>

I can get each part of the code to return, but not as a whole. Below is what I have so far, but it's only returning the Start Time

var p = Portal("https://arcgis.com");

var poles = FeatureSetByPortalItem(p, 'f2180d9e68b3466ab042399a38aea2fd', 0);

var startTime = Min(poles, 'NewTime');

var endTime = Max(poles, 'NewTime');

var TimeElasped = DateDiff(endTime, startTime, 'hours');

var HoursWorked = Round(TimeElasped, 2);

return HoursWorked

var jsonDictionarySTART = {

fields: [{

alias: "STARTTIME",

type: "esriFieldTypeDate",

},],

spatialReference: { wkid: 4326 },

geometryType: "esriGeometryPoint",

features: [{

geometry: {

spatialReference: { wkid: 4326 },

x: -151.0063,

y: 63.069,

attributes: {

startTime,

}]

};

return FeatureSet(Text(jsonDictionarySTART, 'h:mm:ss'));

var jsonDictionaryEND = {

fields: [{

alias: "ENDTIME",

type: "esriFieldTypeDate",

},],

spatialReference: { wkid: 4326 },

geometryType: "esriGeometryPoint",

features: [{

geometry: {

spatialReference: { wkid: 4326 },

x: -151.0063,

y: 63.069,

attributes: {

endTime,

}]

};

return FeatureSet(Text(jsonDictionaryEND, 'h:mm:ss'));

var jsonDictionaryTOTAL = {

fields: [{

alias: "TOTAL_TIME",

type: "esriFieldTypeDouble",

},],

spatialReference: { wkid: 4326 },

geometryType: "esriGeometryPoint",

features: [{

geometry: {

spatialReference: { wkid: 4326 },

x: -151.0063,

y: 63.069,

attributes: {

TimeElasped: HoursWorked,

}]

};

return FeatureSet(Text(jsonDictionaryTOTAL));

Re: Indicator to show start time, end time, and total time.

KenBuja — Fri, 02 Feb 2024 21:01:43 GMT

This is the code to put everything into a single FeatureSet.

However, you can't have line breaks in an Indicator. You can put the individual items in the top, middle, and bottom text

indicator.png

Re: Indicator to show start time, end time, and total time.

AmandaHutsel2 — Tue, 06 Feb 2024 17:02:34 GMT

Thanks for your help @KenBuja . This worked great. I thought that I would be able to filter the information within the indicator itself but was incorrect. I'm now trying to modify the code to filter by inspector and today's date. It's not giving any errors, but only returns null values. Any ideas on this?

var p = Portal("https://arcgis.com");

var poles = FeatureSetByPortalItem(p, 'f2180d9e68b3466ab042399a38aea2fd', 0);

var polesInspector = Filter(poles, "inspected_by = 'Codey Vaughn'");

var polesToday = Date(Filter(polesInspector, "inspected_date = 'Today()'"));

var startTime = Min(polesToday, 'inspected_date');

var endTime = Max(polesToday, 'inspected_date');

var TimeElasped = DateDiff(endTime, startTime, 'hours');

var HoursWorked = Round(TimeElasped, 2);

AmandaHutsel2_0-1707238857171.png

Re: Indicator to show start time, end time, and total time.

KenBuja — Tue, 06 Feb 2024 18:56:20 GMT

Note: when posting code, use the Insert/Edit code sample button

The polesToday variable doesn't have the correct syntax for the SQL92 expression. That doesn't understand any of the Arcade functions, so you have to put that in via a variable. You can also combine your Filters into a single one, if you'd like.

var sql = `inspected_by = 'Codey Vaughn' AND inspected_date > '${Today()}'` var polesToday = Filter(poles, sql)

The code has to use "> Today", since the function Today returns the value "2024-02-06T00:00:00-05:00". Your dates also have a time component, which puts today's records after this value.

Re: Indicator to show start time, end time, and total time.

AmandaHutsel2 — Tue, 06 Feb 2024 19:22:09 GMT

Thank you! This is working great!