Question on Estimated, Remaining, Logged Time Rollups in Filters

[Tim Comella]

Wondering if others may have come across this.  In Advanced Roadmaps, I have one parent Epic and two child Tasks that are linked to the parent Epic.  I enabled Roll Up of dates and others option in the Roadmap.  Enabled Time Tracking in the Tasks.  I can see the hours reported and dates set at the child Task level are showing up and rolling up to the parent Epic.  At question is: when I create a Filter to list out details of the parent Epic and two child Tasks it will show hours recorded at Task level but no calcs are rolling up to parent Epic level in the filter's display.  Any ideas on how to get the Filter to show the rolled up values at parent Epic level, as they do appear in the Roadmap?  Prefer to do this in Jira and not use plugins.

[habib rahman]

Hi @Tim Comella My name is Habib I might have an solution that will help you.

It sounds like you have set up Roll Up of dates and other options in the Advanced Roadmaps for your parent Epic and child Tasks, and enabled Time Tracking in the Tasks, but the rolled-up values are not showing up in your Jira filter.To display the rolled-up values at the parent Epic level in the filter, you can use Jira's JQL (Jira Query Language) to aggregate the values from the child Tasks. Here's an example of how you can achieve this:

1. In the Jira filter, add a new column for the rolled-up value that you want to display, such as the sum of the logged hours for the child Tasks.
2. Use the JQL function `issueFunction` to aggregate the values from the child Tasks. For example, to display the sum of the logged hours for the child Tasks in the filter, you can use the following JQL query:

```
issueFunction in aggregateExpression("parentEpicKey", "sum(\"Time Spent\")")
```In this JQL query, replace `parentEpicKey` with the key of the parent Epic, and `"Time Spent"` with the name of the Time Tracking field in your Jira instance.

3. Save the JQL query and run the filter. You should now see the rolled-up values for the parent Epic in the filter's display.

Note that this approach uses Jira's built-in JQL functions to aggregate the values from the child Tasks, so you don't need to use any plugins. However, it's important to note that Jira's JQL functions have some limitations, so depending on your use case, you may need to use a plugin or custom script to achieve the desired functionality.

I hope this helps

Thank you 

Habib