How to generate Aggregate reports from JIRA ?

[KANNAN SUBBIRAMANI]

Basically I want to generate a aggregated report every day as below,

Input

Project = 'X'

Sprint = currentOpensprint()

COmponents = 'Y'

OutPut (All Day1, Day2, Day3....... should be like series of dates from the beginning of the selected sprint)

Date Status Story Points (Total)

Day1 Open 100

Day1 In Progress 20

Day2 Open 80

Day2 In Progress 20

Day2 Resolved 20

Day3 Open 60

Day3 In Progress 20

Day3 Resolved 20

Day3 Closed 20

Can someone please help me with the solution either Table format or Pie chart (Regular or 3D) or Bar Char (Regular or 3D) ?

[Piotr Bojko]

You can try an addon, like https://marketplace.atlassian.com/apps/1218767 

With an addon you can use SQL instead of  JQL. SQL has aggregating features.

[Rey Catabay]

That link isn't working (anymore).

[Piotr Bojko]

Thanks!

I've updated post with a new link.

Regards,

Piotr