1. Introduction to the Cycle Time Heat Map
The Heat Map is a graphical representation of data (in Kanbanize: cycle time) on a matrix that uses various shades of different colors in order to help distinguish the collected data in each cell of the matrix.
If you have to know which area needs the most attention, the heat map shows you that in a visual way, which is easy to assimilate.
The Heat map shows you where the most time gets accumulated. The red color always stands for higher time values.
- On the "x" axis is the actual workflow of the board (it reflects the workflow stages)
- On the "y" axis, you can choose different topics for example type, owner, priority, etc.
2. Additional controls for this chart
You can use the controls to change the "Heat Map" view as well as to apply additional filters. Please, check the short video below.
- Topic - select a property to change the values represented in the Heat map on the "y" axis.
By default, this will be set to 'Lane'.
- Calculate Cycle Time by - this setting allows you to toggle between showing the Total days spent in each workflow stage or displaying the Average Cycle Time for work items displayed on the chart. In addition, you can use the 50, 70, 85, and 95 percentile options for further aggregation.
- Color Palette - the heat map uses a warm-to-cool color spectrum to show you which parts of your workflow need more attention.
- Show/hide data control that allows you to zoom in and out of a specific interval within the selected time frame.
- Item Filter - allows you to further refine the data that you want to be displayed on the Heat Map.
- Workflow Stages - deselect the columns in your workflow that you do not want to be visualized on the "x" axis.
If you remove a middle stage from the workflow stages of the chart, then you will have results as follows:
- the previous stage will keep the same value
- the stage after the removed one will be calculated, taking into account the time it took for the cards to enter it after leaving the previous stage. The chart would read that the time for a card to move from the previous column to the following column and not the card stayed in the previous column for the time that it spent in the removed column.
3. What's that telling us?
Let's use the priority in the example below.
The heat map shows in which part of the workflow, the cards of high, critical, average priority spend the most time in the columns (in days). The graph accumulates the total number of days that the cards of certain priority spend in each of your workflow stages.
If there is an intersection on the Heat map colored in red, it signals that the cycle time of the tasks there is longer and that stage of your process needs attention. This visualization helps you easily find out the slowest part of the workflow and it is a good way to visualize bottlenecks.
In the example below, the cards with average priority take the most time in the Development/Coding column. If you click on any of the intersections, the system provides a list with all cards that have passed through that stage, so you can check the reasons for deviation easily.
Hover on any Card ID to open the respective "Work Item Details" box. It contains specific information relevant to the card. In addition, you can check the time this card has spent in every stage of the workflow.
That being said, the Cycle Time Heatmap allows for recalculation based on working days.
Note: that the X-axis (where applicable) would still display all calendar days/weeks.
The selection of working days recalculates the cycle time for all cards shown in the graph, but they do not change their position in time. Let's say we have a card that was moved to ‘In Progress’ on a Wednesday e.g. 06.01.2021 and was completed on Saturday 09.01.2021 and the team is working from Monday to Friday.
If no working days option is selected, the card's cycle time would be calculated as 4 days.
If working days are selected (Mon-Fri) for the Cycle time Heatmap, the cycle time for the example card above would be recalculated for each column that the card spent time in, outside of the working days. For example, if a card was in the 'Coding' column before the weekend, then with the exclusion of the weekends the number for the Coding column for a given user (when the Y axis is set to owner) will be calculated for the 3 working days only (Wednesday, Thursday, Friday).
In case that you need precise cycle and log times for internal reporting, use the Advanced search capabilities with the different charts views and widgets.