Each night several test calculations are executed on our system and the results are logged to a database. e.g.
calculation 1 | 2022-12-15 | 5 sec.
calculation 1 | 2022-12-14 | 8 sec.
calculation 1 | 2022-12-13 | 6 sec.
calculation 2 | 2022-12-15 | 20 sec.
calculation 2 | 2022-12-14 | 14 sec.
I would like to display a graph showing the top 10 calculations that have performed slower than last time. This could be an indication that our new system performs slower compared to the previous version.
e.g. by comparing the average length of this week and compare this with the average length for the same type of calculations of last week.
e.g. by comparing the average lenght of this week and compare this with the average length for the same type of calculations of the last 4 weeks
What would be the best way to proceed with this?