VSA "Stage time" metrics - adding P50 (Median), Mean and P90 to the chart

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

Problem to solve

User experience goal

The VSA Total Time Chart provides insights into the distribution of time durations to help users understand and optimize their processes, and users have several different analytical needs:

  1. P50 (Median): Represents the typical case, reducing the impact of outliers and giving users a realistic expectation of the most common duration.
  2. Average (Mean): Provides an overall summary of time spent, helping identify general trends but may be skewed by extreme values.
  3. P90 (90th Percentile): Highlights the worst-case scenarios for the longest-running cases, helping teams identify bottlenecks and optimize performance.

Proposal

Once VSA "Stage time" - Convert line chart to scatte... (#367661 - closed) will be completed adding:

  • Red line = average stage time (= sum(issue time in stage on a day) / (n)issues )
  • P50 = median stage time = 50% of the data points fall below this value.
  • P90 = 95% of the data points fall below this value, and the slowest 5% are above it.
  • P90 = 90% of the data points fall below this value, and the slowest 10% are above it.

TBD

Old

empower users to make data-driven decisions, balance expectations, and identify areas for improvement and show immediate insights about what what's happening in the specific stage by visualizing the performance of the stage.

  1. Adding the the total median time to the chart. (Example).
  2. Add the median time also to the chart tooltip.

Additional information

  • Medians were chosen for VSA because they exclude "outliers" - extremely high or low values that skew averages.
Edited by 🤖 GitLab Bot 🤖