AnsweredAssumed Answered

Reporting on duration of status changes?

Question asked by L.Elias Champion on May 28, 2015
Latest reply on Jun 1, 2015 by Robert Ensinger

We have a custom lookup attribute on our idea object with various statuses. I now I have a request to report on and measure the amount of time ideas are staying in each status. My two initial thoughts are

  1. Enable auditing on the attribute and reporting on that data. I found Report Audit trail Info which seems to be along the same lines but I haven't tried it yet.
    1. I don't like the idea of keeping perpetual audit trail data but not sure if that is a valid concern or not?
  2. Create a slew of new attributes for each status and have a process that records the date the idea got set to the status on change, then report on those dates
    1. This just feels gross, not to mention if something ever goes back to a previous status, it'd lose the original date

Anyone else dealt with this sort of request before and have any pointers?