How much time between two time fields should be displayed?

jamesbondss

 

Hello, i am James from Chicago and a business owner of a tech company.
One of my fields has a "Start" time, and the other has an "End" time. Is there a way to generate a table that shows the average time between those two fields?

I'm still learning how to use insights, so there are many things I want to do but don't yet know how to do them.

JA7

If you click on the the three dots next to your data source name and open up the data table you can calculate a new field that shows the length of time between two dates. 

The calculation you would use is DATEDIF(start_date, end_date, [unit]). The Unit is the unit of measurement you want to calculate:

• "ss" = seconds
• "mm" = minutes
• "h" = hours
• "D" = days
• "M" = months
• "Y" = years

Once this new field has been calculated, you can use it like any other numeric field in Insights to display the average length of time. 

 

Calculate a field in the data table

Functions