track the amount of time a request spent in each status via calculated field(s)

[AbiBeggs]

Hi all,

I'm currently looking to capture the cumulative amount of time a request spends in each different status. I was referencing this old post which has a lot of great information on tracking the dates but I'm looking for the time. Has anyone done this before and do you have any tips?

Thanks!

[KellieGardner · Accepted solution]

This is not possible natively.

Something you can do is run Journal Entry reports to see the status changes or collect the timestamps and run some calculations.

here is one article where it captures the timestamps individually and then you could report on them running datediff calculations.

Solved: Mark Status Timestamp In Field - Adobe Experience League Community - 711297

[Doug_Den_Hoed__AtAppStore]

Hi @AbiBeggs,

I see you've marked Kellie's Journal Entry approach correct, so am glad you got what you needed, but would add that -- similar to my original Targeted Auditing post you mentioned, I have in the past also create series of calculated parameters that tracked the cumulative amount of time a task spends in each different status (technically, each statusEquatesWith, to be more specific).

The approach is quite advanced, would have to be adapted to use on requests, and is beyond what I'd be comfortable posting in this forum...but it is possible.

Regards,

Doug