Hi, I notice an issue regarding the cycle time calculation in the new overlay.
In the “Lead Time” tab, the filtering mode “columns” is selected.
When the items have been moved back to previous statuses by the team, the cycle time calculation in the popup/ overlay window does not add up.
In the Cycle time tab and Table view, the cycle time is shown as 34 days. In the popup, the time in active columns is shown as 81 days.
I already find the popup very helpful to quickly determine the potential bottlenecks and better understand the flow on individual tickets. But the displayed CT seems still off.
Expected behavior:
The Cycle time is calculated as the total time that the ticket spent in all active columns, no matter when they were added to it.
Or is there another way to understand the numbers displayed?
EDIT: I calculated the cycle time manually and 34 days in active columns (33 in sum + 1) seems to be correct.
Thank you,
Markus
Here is the raw JSON, as downloaded by JMP:
{
"key": "HCE-1139",
"starts": {
"0": [
"1734444295581"
],
"2": [
"1740665476273"
],
"3": [
"1741096571432"
],
"4": [
"1741094247147",
"1741187357064",
"1741959386483"
],
"5": [
"1741359112322",
"1743515356135"
],
"6": [
"1743599580173"
],
"7": [
"1741023731340",
"1744029884674"
]
},
"ends": {
"0": [
"1740665476273"
],
"2": [
"1741023731340"
],
"3": [
"1741187357064"
],
"4": [
"1741096571432",
"1741359112322",
"1743515356135"
],
"5": [
"1741959386483",
"1743599580173"
],
"6": [
"1744029884674"
],
"7": [
"1741094247147"
]
},
"currentColumn": {
"name": "Fertig",
"index": 7
},
"durations": {
"0": 6221180692,
"2": 358255067,
"3": 90785632,
"4": 1730049195,
"5": 684498199,
"6": 430304501,
"7": 70515807
},
"columnHistory": [
{
"columnName": "Zu erledigen",
"columnIndex": 0,
"startTime": "1734444295581",
"startTimeFormatted": "17.12.2024, 15:04:55",
"endTime": "1740665476273",
"endTimeFormatted": "27.2.2025, 15:11:16",
"statuses": [
{
"status": "10003",
"startTime": "1734444295581",
"startTimeFormatted": "17.12.2024, 15:04:55",
"endTime": "1740665476273",
"endTimeFormatted": "27.2.2025, 15:11:16"
}
]
},
{
"columnName": "In Arbeit",
"columnIndex": 2,
"startTime": "1740665476273",
"startTimeFormatted": "27.2.2025, 15:11:16",
"endTime": "1741023731340",
"endTimeFormatted": "3.3.2025, 18:42:11",
"statuses": [
{
"status": "10008",
"startTime": "1740665476273",
"startTimeFormatted": "27.2.2025, 15:11:16",
"endTime": "1741023731340",
"endTimeFormatted": "3.3.2025, 18:42:11"
}
]
},
{
"columnName": "Fertig",
"columnIndex": 7,
"startTime": "1741023731340",
"startTimeFormatted": "3.3.2025, 18:42:11",
"endTime": "1741094247147",
"endTimeFormatted": "4.3.2025, 14:17:27",
"statuses": [
{
"status": "10004",
"startTime": "1741023731340",
"startTimeFormatted": "3.3.2025, 18:42:11",
"endTime": "1741094247147",
"endTimeFormatted": "4.3.2025, 14:17:27"
}
]
},
{
"columnName": "Deploy & Test",
"columnIndex": 4,
"startTime": "1741094247147",
"startTimeFormatted": "4.3.2025, 14:17:27",
"endTime": "1741096571432",
"endTimeFormatted": "4.3.2025, 14:56:11",
"statuses": [
{
"status": "10006",
"startTime": "1741094247147",
"startTimeFormatted": "4.3.2025, 14:17:27",
"endTime": "1741096571432",
"endTimeFormatted": "4.3.2025, 14:56:11"
}
]
},
{
"columnName": "In Review",
"columnIndex": 3,
"startTime": "1741096571432",
"startTimeFormatted": "4.3.2025, 14:56:11",
"endTime": "1741187357064",
"endTimeFormatted": "5.3.2025, 16:09:17",
"statuses": [
{
"status": "10012",
"startTime": "1741096571432",
"startTimeFormatted": "4.3.2025, 14:56:11",
"endTime": "1741187357064",
"endTimeFormatted": "5.3.2025, 16:09:17"
}
]
},
{
"columnName": "Deploy & Test",
"columnIndex": 4,
"startTime": "1741187357064",
"startTimeFormatted": "5.3.2025, 16:09:17",
"endTime": "1741359112322",
"endTimeFormatted": "7.3.2025, 15:51:52",
"statuses": [
{
"status": "10006",
"startTime": "1741187357064",
"startTimeFormatted": "5.3.2025, 16:09:17",
"endTime": "1741359112322",
"endTimeFormatted": "7.3.2025, 15:51:52"
}
]
},
{
"columnName": "Deployment (Stage)",
"columnIndex": 5,
"startTime": "1741359112322",
"startTimeFormatted": "7.3.2025, 15:51:52",
"endTime": "1741959386483",
"endTimeFormatted": "14.3.2025, 14:36:26",
"statuses": [
{
"status": "10019",
"startTime": "1741359112322",
"startTimeFormatted": "7.3.2025, 15:51:52",
"endTime": "1741959386483",
"endTimeFormatted": "14.3.2025, 14:36:26"
}
]
},
{
"columnName": "Deploy & Test",
"columnIndex": 4,
"startTime": "1741959386483",
"startTimeFormatted": "14.3.2025, 14:36:26",
"endTime": "1743515356135",
"endTimeFormatted": "1.4.2025, 15:49:16",
"statuses": [
{
"status": "10006",
"startTime": "1741959386483",
"startTimeFormatted": "14.3.2025, 14:36:26",
"endTime": "1743515356135",
"endTimeFormatted": "1.4.2025, 15:49:16"
}
]
},
{
"columnName": "Deployment (Stage)",
"columnIndex": 5,
"startTime": "1743515356135",
"startTimeFormatted": "1.4.2025, 15:49:16",
"endTime": "1743599580173",
"endTimeFormatted": "2.4.2025, 15:13:00",
"statuses": [
{
"status": "10019",
"startTime": "1743515356135",
"startTimeFormatted": "1.4.2025, 15:49:16",
"endTime": "1743599580173",
"endTimeFormatted": "2.4.2025, 15:13:00"
}
]
},
{
"columnName": "Bereit für Abnahme",
"columnIndex": 6,
"startTime": "1743599580173",
"startTimeFormatted": "2.4.2025, 15:13:00",
"endTime": "1744029884674",
"endTimeFormatted": "7.4.2025, 14:44:44",
"statuses": [
{
"status": "10007",
"startTime": "1743599580173",
"startTimeFormatted": "2.4.2025, 15:13:00",
"endTime": "1744029884674",
"endTimeFormatted": "7.4.2025, 14:44:44"
}
]
},
{
"columnName": "Fertig",
"columnIndex": 7,
"startTime": "1744029884674",
"startTimeFormatted": "7.4.2025, 14:44:44",
"endTime": null,
"endTimeFormatted": null,
"statuses": [
{
"status": "10004",
"startTime": "1744029884674",
"startTimeFormatted": "7.4.2025, 14:44:44",
"endTime": null,
"endTimeFormatted": null
}
]
}
],
"reconstructedTransitions": {},
"rawChanges": [
{
"key": "HCE-1139",
"columnTo": 0,
"statusTo": "10003",
"timestamp": "1734444295581"
},
{
"key": "HCE-1139",
"columnFrom": 0,
"columnTo": 2,
"statusTo": "10008",
"timestamp": "1740665476273"
},
{
"key": "HCE-1139",
"columnFrom": 2,
"columnTo": 7,
"statusTo": "10004",
"timestamp": "1741023731340"
},
{
"key": "HCE-1139",
"columnFrom": 7,
"columnTo": 4,
"statusTo": "10006",
"timestamp": "1741094247147"
},
{
"key": "HCE-1139",
"columnFrom": 4,
"columnTo": 3,
"statusTo": "10012",
"timestamp": "1741096571432"
},
{
"key": "HCE-1139",
"columnFrom": 3,
"columnTo": 4,
"statusTo": "10006",
"timestamp": "1741187357064"
},
{
"key": "HCE-1139",
"columnFrom": 4,
"columnTo": 5,
"statusTo": "10019",
"timestamp": "1741359112322"
},
{
"key": "HCE-1139",
"columnFrom": 5,
"columnTo": 4,
"statusTo": "10006",
"timestamp": "1741959386483"
},
{
"key": "HCE-1139",
"columnFrom": 4,
"columnTo": 5,
"statusTo": "10019",
"timestamp": "1743515356135"
},
{
"key": "HCE-1139",
"columnFrom": 5,
"columnTo": 6,
"statusTo": "10007",
"timestamp": "1743599580173"
},
{
"key": "HCE-1139",
"columnFrom": 6,
"columnTo": 7,
"statusTo": "10004",
"timestamp": "1744029884674"
}
]
}