Summary

This article offers information about the situation where a CSV export is carried out, but the Time Spent rollup from the subtasks isn't exported for the Story Issue type even though the information is visible in the UI.

Environment

Jira Cloud

Diagnosis

The CSV export would only have the information for the time directly logged on the Story issue type in the Time Spent field however the time rollup from the subtasks isn't exported. If no time was logged on the Story Issue type then the value in the Time Spent field shows as 0 and wouldn't include the roll-up from the subtasks.

Solution

The "Time Spent" column in the CSV exported showcases the duration logged directly on the Story issue type. For viewing the total time rollup from the subtasks in the CSV export, it's essential to add the "Σ Time Spent" column. To address this, you must:

• Run the JQL query.
• Incorporate the ΣTime Spent column prior to exporting the issue to the CSV.
• After the addition of this column, the total time spent (Σ  Time Spent) details can be scrutinized in the UI.
• The export should now encompass the information with the cumulative data from the subtasks.
• • 
• The export should now have the information with the roll-up from the subtasks.