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
- 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.
- I don't like the idea of keeping perpetual audit trail data but not sure if that is a valid concern or not?
- 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
- 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?