Provide statistics on metrics

[Sebastiaan127001]

Is your feature request related to a problem? Please describe.
I'm always frustrated when development teams ask me to configure a good threshold value for metrics like 'violation remediation effort' or 'CI pipeline duration'. A good practice would be to base the threshold on historic trends, but currently, it is not possible to see the average or median of a metric value.

Describe the solution you'd like
It would be useful to have more details in the trend section of a metric. For instance, when I select a part of the trend graph, I would like to more details on that selection. Preferred details would be: min, max, avg, median, 90th percentile.

Add a table with statistics to the right of the trend graph. Update the statistics when the user pans or zooms the trend graph.

| Statistic | value |
|=====|===|
| Average | 123 |
| Minimum | 20 |
| 10% percentile | 25 |
| 50% percentile (median) | 100 |
| 90% percentile | 140 |
| Maximum | 150 |

Describe alternatives you've considered
None

Blocked by

• Improve Trend Graph - pan and zoom #3587