Minimum and maximum values in dashboard chart

English Forum Product Feedback
1

Lead time (time to complete) is an important process metric. Both for internal proces evaluation, and for sharing process metrics to give clients an indication of performance.

In a dashboard chart, I can choose to display either Sum or Average.

image
image395×236 2.57 KB

When looking at a process, the average is good to know. But what I’d also like to know are the maximum and the minimum values.

Especially the maximum is good to know, as it indicates the worst performance. Without it I won’t be able to tell from the dashboard whether I am keeping my promises when I’ve promised maximum lead times.

The minimum is also good to know, as together they indicate the best performance.

These are the charts I use currently:

image
image1526×946 25.8 KB

Top:

  • Chart type: bar
  • X-axis: Week (based on task creation)
  • Y-axis: Average time to complete in hours

Bottom:

  • Chart type: Bar
  • X-axis: Week (based on task creation)
  • Y-axis: Task count

Together I can reason that for 16/02:

  • the maximum time would have been between 4.07 hours and 8.14 hours
  • the minimum time can’t have exceeded 4.07 hours

That’s just a rough estimate though, and it doesn’t give an indication of the variation in the process.

The more tasks per unit of time, the more obscure this becomes.

PS: Ideally I’d be able to see the minimum, maximium, and the average in one chart, but I would consider that a bonus/nice follow-up.

1 Like
2

Have you seen a recent post from @Arthur_BEGOU about the way we display targets in charts using grouped bar charts? This is a workaround in your case for sure, but pretty decent.

2 Likes
3

This one 📊 Reports: Data and Target side by side :wink:

1 Like
4

@Bastien_Siebman @Arthur_BEGOU

I’m not sure I understand. It would work if the target were something cumulative like total hours spent, but I’m looking to separate both the minimum and the maximum values out of multiple lead times within a given timeslot.

So, let’s say I handled 5 requests in a week, I would like to know the minimum lead time (fastest time to complete) and the maximum lead time (slowest time to complete).

I don’t see how the article helps me in determining those.

5

Indeed it would work if you wanted to show always the same max and min (boundaries)

6

But I’d only be able to tell if my average was off, not if there were individual measurements off.

Sure, it might help to compare the averages to the target but I don’t see it addressing the core of my issue.