I'm trying to filter down the data of two different columns. I have exported the Time Tracking Report from JIRA which consists of the following columns:
Issue Type Key Status Priority Summary Original Time Estimated (min) Σ Estimated Time Remaining (min) Σ Total Time Spent (min) Σ Accuracy Σ Accuracy (%) Σ
I'm interested in filtering down both Issue Type Key Status
.
Key Status is unique to each row e.g. EP-1234
Issue Type includes several value types, but I'm generally interested in three: story, sub-task and sub-bug.
It would be quite easy for me to narrow down the stories (there are about 10 in a given sprint, but each story has a large number of sub-tasks and sub-bugs directly below in the column Issue Type for example:
Issue Type. Key Status
Story EP-2643
-> Sub-task EP-2717
-> Sub-task EP-2716
-> Sub-task EP-2715
-> Sub-task EP-2714
-> Sub-task EP-2713
-> Sub-task EP-2712
Both stories and -> Sub-tasks are located in the same column and other than an order there is no connection between the story EP-2643 and it's sub-tasks. Is there any filter or query,or script that would allow me to somehow pair this data automatically? I can do it manually of course, but if I have to do it everyday, it won't be efficient.