Skip to main content
1 of 4

Filter the data of two different column

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.

Thanks for looking into an issue