I have a requirement to create some metrics, reports or performance analytics (whichever will accomplish what I need) to show the average stage duration of requested items (generated from a specific catalog item) over a period of time (a week or month). I am able to do this with reporting on the metric_instance table using a metric definition I set up, BUT I need to be able to also include the stage duration of these requested items that are currently in a stage (i.e. stage has not changed so calculation complete = false). I was able to add a custom field labeled Current Duration and included a script to calculate the duration based on the start date and today's date, BUT I cannot report on this calculated field - no data is returned.
Is there any way to show a trend of the stage (4 stages total) duration for requested items (generated from a specific catalog item), and also include ones who do not have a calculation complete = true, value?
