Skip to main content
2 of 4
deleted 57 characters in body
serenesat
  • 10k
  • 30
  • 33
  • 50

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.