Metric Intelligence (Fetch Report for metric data)

[Tanisha Jain]

How can I fetch the report for metric data from service operation workspace? 

[Mark Manders]

Create a report and use the metric_instance table as your source (include the filters you need).

[Amarjeet Pal]

Hello @Tanisha Jain ,

Could you please elaborate  what report you are looking for? Are you looking to create a report on SOW workspace?

If yes then explore UI builder data visualization.

Thanks

Amarjeet Pal

Advania UK

[Yashsvi]

Hi @Tanisha Jain,

To fetch the report for metric data from Service Operation Workspace in ServiceNow, follow these steps:

1. Navigate to Reports:

- Go to 'Reports' > `View / Run'

2. Create a New Report:

- Click on the `Create a report' button.

3. Choose the Data Source:

- In the 'Data' tab, select the 'Metric' table ('metric_instance')

4. Configure the Report:

- Type: Choose the type of report you want (bar chart, pie chart, list, etc)

- Name: Provide a name for your report

- Filter Conditions: Set up the conditions to filter the metric data according to your requirements

5. Select Group By and Aggregation:

- Group By: You can group the data by relevant fields like 'metric_definition', 'task', 'metric_date', etc., depending on what you want to analyze.

- Aggregation: Use appropriate aggregation methods like count, sum, average, etc., to summarize the metric data.

6. Save the Report:

- Click on the 'Save' button to save your report.

7. Access the Report in Service Operation Workspace:

- Go to the Service Operation Workspace.

- Use the embedded 'Reports' module or a custom widget to display the report you created.

- You may need to configure the workspace to include the report by adding it to a dashboard or a specific section within the workspace.

If this answer was helpful, I would appreciate if you marked it as such - thanks!