need to create azure synapse metric

Vikram_Panneeru 

To display the success/failure percentage of multiple pipeline runs for the last 7 days in a chart, you can use Azure DevOps Analytics service.

Here's how you can do it:

• Open Azure DevOps and navigate to the Analytics service.
• Click on "New Chart" and select "Grid" as the chart type.
• Select the "Pipeline" table as the source table.
• Add the following fields to the chart:
      "Result" field to group the runs by their result (Succeeded or Failed).
      "Pipeline Name" field to group the runs by their pipeline name.
      "Completed Date" field to filter the data to the last 7 days.
      "Count" field to count the number of runs.
• Click on the "Options" tab and select the "Percentage" option under the "Aggregation" section.
• Click on the "Settings" tab and configure the chart settings as per your requirements.
• Save the chart and view it on the Analytics dashboard.

This chart will display the success/failure percentage of the pipeline runs for the last 7 days in a grid format. You can customize the chart to display the data in a different format or add more fields as per your requirements.

Further follow this documentation :Pipeline reports