Metrics on demand

CV1
Tera Contributor

Hi All,

We have a requirement to create a report to show demand state and how long that demand is in that state.

I created a metric on dmn_demand table and on state field, and created a report based on metric_instance where it shows  fields "

Created| Definition (demand) | ID| Value| Start| End| Duration.

The report need to also show who is it assigned to. Metric can be done on 1 field . Please advise how to address this requirement.

 

CV1_0-1686085924391.png

 

 

TIA.