{"id":3641,"date":"2024-10-28T01:13:00","date_gmt":"2024-10-28T05:13:00","guid":{"rendered":"https:\/\/www.pacemkr.ca\/?p=3641"},"modified":"2024-10-02T14:32:08","modified_gmt":"2024-10-02T18:32:08","slug":"filter-by-workflow-stages","status":"publish","type":"post","link":"https:\/\/pacemkr.com\/fr-ca\/tutorials\/filter-by-workflow-stages\/","title":{"rendered":"Filter by workflow stages"},"content":{"rendered":"

To have a broader understanding of this tutorial, it is advised to read the tutorial States and directions of work items before moving forward.<\/p>\n\n\n\n

Introduction<\/h3>\n\n\n\n

Pacemkr offers the ability to filter your data by workflow stages (or columns). This means you can select the stages you want based on the perspective you want to have on your work items.<\/p>\n\n\n\n

For example, you could have the following workflow:<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

For whatever reason, you might want to look at work items from the Building to \u2018Done\u2019 columns:<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Or maybe it\u2019s the other way around and you want to look from the \u2018To Do\u2019 to \u2018Building\u2019 columns.<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

The rest of this tutorial will highlight different situations when you select specific columns of your workflow. It can give you the impression that Pacemkr doesn\u2019t calculate correctly your metrics but once you have a strong understanding of how specific scenarios are considered, we hope it will make more sense.<\/p>\n\n\n\n

Cycle time<\/h2>\n\n\n\n

As you select a subset of your workflow, your cycle times and the overall Service Level Expectation can give fluctuating values. It is important to consider the following situations as they are the most probable cause of changes in cycle time values.<\/p>\n\n\n\n

Selecting only the first and last columns<\/h3>\n\n\n\n

There are situations where some of your work items go directly from your first to last column without touching any other columns. This situation can happen when you are cleaning your list of things to do. Some items are already done or will never materialize.<\/p>\n\n\n\n

For these reasons, you send your work items to the \u2018Done\u2019 column like in the following image:<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Let\u2019s use the grid notation to calculate its cycle time. In the following image, the cycle time of work item A is 5 days (Friday – Monday + 1).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now let\u2019s say the user only wants to look from \u2018Building\u2019 to \u2018Done\u2019. By only selecting those columns in Pacemkr, our workflow will look like this:<\/p>\n\n\n

\n
\"\"<\/figure><\/div>\n\n\n

Using the grid notation, we have:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How can we calculate the cycle time of work item A when we don\u2019t have its starting time, i.e. Monday?<\/p>\n\n\n\n

There are 2 options here:<\/p>\n\n\n\n