JQL Query needed for open tickets per type at the beginning of each month.

[Sharmaine van Eden]

I urgently need assistance in establishing a JQL search query that will provide me with the amount of open tickets (per type) at the beginning of each month.

[Sebastian Kleinholz]

There is a scheduler out there that can do what you want. Create your own JQL and let it execute once a month. Search for "Chronos for Jira" on the marketplace.

[Kian Stack Mumo Systems]

Try creating a dashboard with the results of a filter. 

1) Create a new filter. I'd recommend filtering for "resolution is EMPTY and created <startOfMonth()". This will give you all open tickets from the beginning of the month.

2) Save query as something like "Open tickets at beginning of the month". 

3) Create a new dashboard with a  gadget for "ISsue Statistics". Select your filter saved in step 2 and choose the statistic type "Issue Type".