Metrics on demand

CV1
Tera Contributor

‎06-06-2023 02:12 PM

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.

0 Helpfuls
  • 671 Views
2 REPLIES 2

debu85
Giga Contributor

‎06-08-2023 03:09 AM

• Create a report to show demand state and how long that demand is in that state. • Create a metric on the dmn_demand table and on the state field. • Create a report based on metric_instance which shows fields such as Created, Definition (demand), ID, Value, Start, End, Duration. • The report should also show who the demand is assigned to. • Metric can be done on one field.

For asking ServiceNow-related questions try this :
For a better and more optimistic result, please visit this website. It uses a Chat Generative Pre-Trained Transformer ( GPT ) technology for solving ServiceNow-related issues.
Link - https://nowgpt.ai/

For the ServiceNow Certified System Administrator exams try this :
https://www.udemy.com/course/servicenow-csa-admin-certification-exam-2023/?couponCode=NOW-DEVELOPER

0 Helpfuls

Maddie Wolf
Tera Contributor

‎09-05-2024 10:40 AM

We have a similar ask, but also want to include those demands that are currently active. Our team built the metric to capture the data once the demand closes (rejected or completed demand state). Did you figure out how to capture the metric while the demand was still active (i.e. draft, submitted, screening, qualified, approved states)?

0 Helpfuls