topic Re: Display amount of time between two time fields? in ArcGIS Insights Questions

Display amount of time between two time fields?

SaraHedrick1 — Thu, 11 Aug 2022 16:44:50 GMT

I have two fields, one with a 'Start' time and the other with an 'End' time. Is there a way I can calculate the average time between those two fields and display it in a table?

I'm still new to insights, and there are a lot of things I want to do, but I'm still figuring out exactly how to do it.

Re: Display amount of time between two time fields?

LauraBecht — Thu, 11 Aug 2022 17:14:22 GMT

Hey Sara,
Right click on the layer in the table of contents, click on data table, add field, name the field, then click to calculate the field and select the start and end time fields to calculate the difference. I think there should be a function you can use. Then you can just add it as a table card.
-Laura

Re: Display amount of time between two time fields?

LLyons — Wed, 18 Dec 2024 15:54:06 GMT

Hi @LauraBecht , is there a way for this to automatically happen? We'll have new records in the dataset and I'd like to find a way to make this field populate automatically. Thanks!

Re: Display amount of time between two time fields?

LauraBecht — Wed, 18 Dec 2024 17:45:57 GMT

My understanding is that if your data is in an SDE or other network/cloud database, any changes to it are automatically updated in insights when you open the workbook. The workbook stores the calculation you made to the table in the workbook, so any new records should automatically be calculated.

If your data is in a local gdb, then you would need a process to add the new gdb to insights, then update the table in the workbook with the new gdb table.

ESRI folks, please correct me if I am wrong.

-Laura

Re: Display amount of time between two time fields?

LLyons — Wed, 18 Dec 2024 17:52:08 GMT

Appreciate you!