Need automatic aggregation in terms of dates, efforts and % completion at parent-level

[Iram Masood]

I need to automatically do the aggregation in terms of dates, efforts and % completion at parent-level/summary task .How would i Do this.

[Iram Masood]

Can anyone help here please.I need this on urgent basis.

[Stuart Capel - London]

Hi Iram,

You could use the Excel or Google Sheet plugins to create a report in a spreadsheet that would give you this information.

If you want to set up a Google Sheets or Excel report go to

'Issues' in your project

and select 'Advanced Search' (top right of screen).

From here you can filter down the issues to include using basic search or JQL, and there are Sheets and Excel icons to allow you to export the issues. First time round you'll need to install the relevant add-on and allow access so you may need to check with IT.

I love the Google Sheets add-on because it lets me set up a datadump which I build reports off in separate tabs and I can schedule it to refresh hourly (that's the best bit). Of course you wouldn't want that frequency with a large data set - daily and out of hours would be best.

[Iram Masood]

I  dont want the report instead i want these values to be displayed in some field in the parent .