Query to create filter which shows number of tickets created each day in last 7 days.

Question

I need to create gadget for dashboard which shows number of tickets created each day in last 7 days.

This is very much similar to "Recently Created Issues Report" that jira provides, but I need this in a form of gadget in my dashboard. Now I can use "Recently Created Chart" gadget, but I need the query to create the filter which could be used inside this gadget.

Nic Brough -Adaptavist- · Answer

Could you please read the answer I gave before?  That explains how Jira's search works and what you will need to do to get what you want.

Pratik singh_a7q2h9 · Answer

Thanks @Nic Brough -Adaptavist-

I tried "created > -7d" but it gives a cumulative result of the last 7 days. Instead, I wanted the results of the total tickets created on each individual day.

I wanted something similar to what Jira provides in "Recently Created Issues Report" as shown below. And for this, I needed the query to help me achieve the required filter.

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

Queries or filters do not have anything to say about how you display the results of them.  A query simply returns a list of issues that match some criteria.

The query you need here is simple: "created > -7d" will get you a list of issue created in the last 7 days.

How you display that is up to the gadget, display (issue navigator), report, or other viewing mechanism to do.

There is no report that does grouping of numbers that you are asking for here, so you'll need to find or write an app that can provide one.

Or you could do a fiddle - write an automation or script that stamps a day name on to every issue based on the created date, and then use a gadget like the "filter statistics" that can display the results of a filter and group them by a field (like day name)