How to create custom bar charts with JQL in JIRA

[A]

I have previously worked with JQL's and gadgets in JIRA. However this time I came across a scenario which has me scratching my head. Request you to kindly help me in designing a suitable JQL for the below mentioned use-case's :

1). Is there any way to create chart with busiest day of the week by month for all the issues in a project. Attached is the screenshot 1.jpg1.jpg

2). Is there any way to get chart showing number of Issues vs. Requests received by month for 2015. Attached is the screenshot 2.jpg2.jpg

3). Is there any way to get chart showing number of tickets per custom field value by month for 2015. Attached is the screenshot 3.jpg

3.jpg

Many Thanks

Akshay

[Nic Brough -Adaptavist-]

JQL is for finding issues, not reporting on the results.  All it does is return a list of issues.  You then hand that list of issues to something that will extract data from and report on the issues (even the issue navigator does that - you define a filter, it shows a simple grid of the results, one issue per row, with the columns you've chosen.  The filter says nothing about the report you see)

So, the JQL you need for each question:

1. Project = X
2. Created > startOfYear()
3. Created > startOfYear()

But the reports are going to be harder - although there is a "created vs resolved" chart in the gadgets and project reports, it's nothing like what you're asking four.

All three of your reports need some coding.  Not necessarily a report add-on, because you could, with the help of the Script Runner add-on (or others that can do scripts) populate a "month raised" select list field on the issues when they are created.  With that field available, all three of your reports become possible to do with the "2 dimensional statisics" gadget on the dashboard, as you can select the month as one axis, and any other field as the other.