[VSA] Date range filter should apply to end events
<!-- triage-serverless v3 PLEASE DO NOT REMOVE THIS SECTION --> *This page may contain information related to upcoming products, features and functionality. It is important to note that the information presented is for informational purposes only, so please do not rely on the information for purchasing or planning purposes. Just like with all projects, the items mentioned on the page are subject to change or delay, and the development, release, and timing of any products, features, or functionality remain at the sole discretion of GitLab Inc.* <!-- triage-serverless v3 PLEASE DO NOT REMOVE THIS SECTION --> ### Overview As described in https://gitlab.com/gitlab-org/gitlab/-/issues/330789, users want to see how long stage times were taking in a given time period. For example, "what was my slowest stage in my value stream in April?", "did it improve in May?". It is not possible to do that in VSA today because the date selector only considers the issue creation date. [Demo of current behavior](https://www.youtube.com/watch?v=9iA3Oh14YGU&t=109s) ### Proposal When a user selects a date range in VSA, filter stages as follows: 1. Find all workflow items that met the end event during that date range 1. Calculate the stage time using the full set of data collected in No. 1 1. Show a list of all the workflow items that completed the stage in the selected date range 1. Provide tooltips and messaging in the UI that clearly explains how the date selector is applied, how the stage time is calculated, and how the list of workflow items is determined. Additionally, adjust Lead Time and Cycle Time to show time metrics based on the issues closed in the selected date range. ### Disclaimer This page may contain information related to upcoming products, features and functionality. It is important to note that the information presented is for informational purposes only, so please do not rely on the information for purchasing or planning purposes. Just like with all projects, the items mentioned on the page are subject to change or delay, and the development, release, and timing of any products, features or functionality remain at the sole discretion of GitLab Inc.
epic