WIP chart line keeping historical transition data

Questions & Answers
, ,
1

Hello,

I´m looking for help in how to setup a WIP line chart that maintains historical data. Here is what I need:

1 - In current WIP chart, if I close an issue within week 40, it will decrease from previous week as well. I wondering if it is possible to recreate the chart for what is on progress/on review using the dates between transitions for that. For example: if issue A in on prgress from week 30, it will count on WIP until it moves to closed on week 34. When this happen the WIP curve should decrease. Visual example:

                 Week        30    31    32    33     34      35

WIP with issue A 1 1 1 1 0 0

Thank you in advance

2

Hello @wolgrand,
Welcome to the eazyBI Community! :wave:
To create a WIP chart that maintains historical data based on transition dates, you can use the “Issues history” measure along with the relevant “in progress” statuses. Here’s a brief outline of the steps:

  1. Use the “Issues history” measure in your report.
  2. Add the “Transition Status” dimension and select the statuses that represent your “in progress” work (e.g., “In Progress”, “In Review”, etc.).
  3. Use the Time dimension to show the data by week.

This approach will maintain the historical WIP count even after issues are closed, reflecting the actual state of work for each week based on transition dates.

For more detailed information on using the “Issues history” measure and creating charts, please refer to the eazyBI documentation: See Import issue change history documentation

Kind regards,
Gerda // support@eazybi.com