Forum Discussion

MathewCrist's avatar
MathewCrist
Qrew Member
5 years ago

Create a report that shows time between timestamps

Hi, I need to calculate the time between 2 timestamps Time between: Lead Created and Call Attempt 1 Call Attempt 1 to Call Attempt 2 Call Attempt 2 to Call Attempt 3 What is the be...
reports and charts
MathewCrist's avatar
MathewCrist
Qrew Member
5 years ago

Hi Mark,

I'm trying to take account of how long we take to call someone from the time a lead comes in (Date created to Call Attempt 1). Beyond that, I would also like to determine how long it has been since the last attempt.

Knowing this will give us more visibility as to:
1) how long we generally take to reach out to our leads
2) When it's time to try again (i.e. Call attempt 1 was 72 hours ago = time to try again).

Thanks!

Matt

------------------------------
Mathew Crist
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Can you give me an example of a single record (say the first one on that list if you like) and the correct calculated result.

If you just want to know the number of days, then it would be

ToDays(ToDate([call attempt 1]) - ToDate([Date Created]))

The above would be a formula numeric field.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------