Displaying Epics, SubTasks and Duedate in a table format as pivot

[Munir Patel]

Hi

Is there anything in Jira or reports/dashboard or app that will allow me to see as enclosed. In the example enclosed, Due dates are the ones that are for SubTasks. Please note. Subtask1,2 and 3 Summary Name is same for all Epics.

..

[Carlos Garcia Navarro]

Hi @Munir Patel ,

I don't know if this would work, but this Confluence app may be useful (I haven't used it but it seems that it can integrate well with Jira):

Table Filter and Charts for Confluence

https://marketplace.atlassian.com/apps/27447/table-filter-and-charts-for-confluence?hosting=cloud&tab=overview

[Katerina Rudkovskaya [Stiltsoft]]

The Table Filter and Charts for Confluence app is our add-on and it works with Confluence, not Jira.

Our macros support the Jira Issues macro, so you’ll be able to aggregate, calculate and visualize Jira data right on Confluence pages. But again, we work only with the data provided by the Jira Issues macro.

[Munir Patel]

Will the app allow me to pivot Jira filter data in confluence similar to my request in table format with Epics in rows and Subtasks in columns with their due date at intersection.

[Katerina Rudkovskaya [Stiltsoft]]

To build the pivot table based on Jira Issue, please wrap the source table with Table Toolbox in Confluence Cloud and configure Pivot Table as you need.

[Katerina Rudkovskaya [Stiltsoft]]

@Munir Patel, please give me more details on how your Jira Issue looks like (namely Epic, Subtasks, Due date of subtask columns) so I could provide you with a solution in your specific case.

[Munir Patel]

Hi Katerina, I am enclosing the structure for your info.

Epics, SKUs, Subtasks. Under an EPIC there will be several SKUS and each SKU will have the subtasks with same summary names...

What I want is to display in pivot structure where SKUs are in Rows and Subtasks in columns and due date as values in Subtasks....I am enclosing another file as an example..

[Katerina Rudkovskaya [Stiltsoft]]

Please see the example on how you can reach the requested result in Confluence. It's created in its Server version, but you can do the same in Confluence Cloud using Jira Issue and the Table Toolbox macro of Table Filter and Charts for Confluence.



The SQL query from the example:

SELECT T1.'Key',T1.'Summary',
T2.'Key' AS 'Sub-task key',
T2.'Summary' AS 'Sub-task summary',
T2.'Created' AS 'Sub-task created'
FROM T1 LEFT JOIN T2 ON T1.'Sub-Tasks'->split(" ")->indexOf(T2.'Key'::string) > -1 



Please refer to our support portal if you try this solution and have further questions.

[Munir Patel]

Thank you Katerina I will check the suggestion you have sent out sometime this week or early next. Will keep you informed. 

[Rahul_RVS_Support]

Hi @Munir Patel 

If you are fine with a mktplace app, you can try out our add-on.

Issue Hierarchy Reports 

The app will certainly show you the data as per you need but in a tree view.

You can generate insights such as below and also hightlight over due/ nearing due issues:

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

- Sum up Time Spent, Org Estimate, Time Rmng, custom number
fields

- Epic Hierarchy on Issue Screen

Disclaimer : I work for the vendor who built this app

[Hannes Obweger - JXL for Jira]

Hi @Munir Patel

this may not be exactly what you're looking for, but I believe you could get very close with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for issue hierarchies, issue grouping, sum-ups, and conditional formatting. With these, you can build a wide range of interactive reports, including something like this:

(This is based on tasks rather than sub-tasks, but it would work the same for sub-tasks.)

Any questions just let me know,

Best,

Hannes