I'm working on creating a report to identify and understand how long issues are in the "New" status & "In Progress" status. Ideally, it would be a journal entry report that gave me either date that status began and the date ended OR would give me the duration that status was active.
Any help would be appreciated!
You can't
Journal entries give you the date the event was recorded and some info on what changed.
When You run a report on fieldName=status you will see a bunch of edit entries where the status actually didn't change (some other edit was done)
Your best bet is to use calculated fields that set today's date when status changes.
Simple example:
IF({previousStatus}!={status}&&{status}="INP", "Changed to "+{status}+" on "+$$TODAY, {DE:changeToINP})
you'll need 2 such fields one for when New changes to INP and one for INP changing to CPL
If you want to calculate differences then you need to have this field be of type date, and set it to $$NOW, and then in the report you can show a dateDiff column
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.