Report on state changes

[Gemma4]

Is there a way to run a report that shows which changes went to a different state during a certain time frame? For example, I want to report on all changes that went from Approved to Implement to State during a certain timeframe. 

I found I can report state changes in sys_audit, but the change request number does not display and neither do the old and new values are. While I appreciate being able to report on state changes out of the box, the details can't be  presented. If possible I need to try to achieve this with minimal customizations.  Thanks for any feedback you can provide.

[Dr Atul G- LNG]

Hi @Gemma4 

The best way is to create the report on metric table. or please check OOTB, if any metric available on the change table and field is State, which provide you all required results.

[swathisarang98]

Hi @Gemma4 ,

You can create a simple metric Definition as below ,

Note: it will capture the changes once the record is updated but will not work for past data, if the record state changes after the creation on this metric then it will capture

and you can create a report for the same,

Table: metric_instance

type : List

Group by: ID 

In condition : Definition is give the newly created metric name

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[Gemma4]

Thank you for the feedback. However still need a little more help and don't think I explained well. I need to report on if a change goes back to a state. For example if a change is in draft then approved to implement but then goes back to Draft. I need a list of the changes that were reverted back to Draft because of an issue. Currently using the metric I'm only able to view the values