Dashboard gadget "Created vs. Resolved" filter search

Question

Trying to accomplish the following:

Show in a dashboard "Created vs Resolved" epics and initiatives created in several projects for only the current year but I got stuck on what JQL filter query I should create to make it work.

at the moment I got stuck at this:

project in (CPPC, CFA, DNEWCPI, ROBG, RSCRSB) AND issuetype in (Epic, Initiative) AND status changed to Done after startOfYear() AND status = Done

But this will cause the gadget to show issues created as far back as the number of days that I set in the gadget (for example 900) instead of only showing created during current year:

There must be a smarter solution to only showing created vs resolved during current year?

Danut M _StonikByte_ · Answer

Hi @Andreas Rossi ,

Unfortunately this Jira gadget (as well as the "Recently Created Chart" gadget, which also displays the created vs resolved) only allows entering the number of days back. So you will not be able to configure the gadgets to display data since the beginning of the year.

A solution would be to look for an app on Atlassian Marketplace that provides such chart, which allows you to enter a date range.

If you consider the idea of using an app, then our Great Gadgets app can be a good solution, because it includes a gadget that allows you to set a start date (January 1st in your case).

See this article on how to configure the gadget: A powerful Reported vs Done chart for Jira dashboards. If you have any questions, please contact support@stonikbyte.com.

Danut.

Andreas Rossi · Answer

Ok thank you, I guess there isn't a possibility to have this gadget work as a current year rolling report then sadly. 
It is quite limiting with having to use external tools to display quite basic statistics :)

Is there a good way to report these limitations and suggest future enhancements to the dashboard and gadgets?

Duc Thang TRAN · Answer

@Andreas Rossi

The filter serves as the main scope of your report, while the "days previously" acts as a sub-filter.

For example, in your case, you are retrieving issues created since the start of the year (240 days ago). If you set "days previously" to 300 days (the maximum value), it will broaden the filter criteria, but it will return zero results if there are no issues within that extended timeframe.