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

Pratik singh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 9, 2023

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.

 

 

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 9, 2023

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)

Pratik singh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 9, 2023

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.

 

jira 1.png

 

jira2.png

 

 

jira3.png

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 10, 2023

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.

Suggest an answer

Log in or Sign up to answer