Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to create custom reports in JIRA

hi Team,


I am aware that there is automated report for Jira that can be scheduled by creating subscription, but I need custom columns in that. LIke Created and updated date in Jira can give me one more column open days for the ticket. Is it possible. Please help on this.

1 answer

0 votes

Hi Ruchi

You can customize the columns of your filter to specify what kind of info you want to receive by subscription. Open your filter, click the Cog icon and pick Configure Columns. Then pick the Columns you want to display and set them in the desired order. Thos settings will be saved together with the filter.

Hey Daniel,

Thanks for responding back.

I think i did not frame my question correctly, My bad.

I can select the column which I want but what I can not do is manipulation of those columns.

Example, I can see there is a column "Created Date" but based on this I need to add another column which should be "Open for # of Days".


Also I am not able to get the report in proper format in the email.

Please also suggest me in getting proper HTML format report.



Thanks and Regards,


Hi Ruchi

The column you can add has to be a valid field for your Jira project. Do you have field "Open for # of Days" in your Jira project? Jira out of box does not support such a field, you can add a custom field and then using "script runner" to specify the behavior of it, for example, number of days the issue has been opened.

Alternatively, if you were just concern about issues that opened beyond X number of days, a simpler method is to use a JQL like "created < endOfDay(-X) ", which returns the issue created before X days from today.

 I am not quite familiar with Subscription format either, but I found this one, hope it help:

"The column you can add has to be a valid field for your Jira project. Do you have field "Open for # of Days" in your Jira project? " - Can I create a column in my project?

Hi Ruchi

I guess you were asking how to add a custom field into your project? 

Yes, but you do need to have Jira Admin permission.

Please refer to

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events