nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automatic JQL Query

Muhammad Bilal_r2rxjd

Hi,

I have couple of request that needs to be done on our Jira Cloud, let me know please how can i achieve the below points successfully.

1) How to create a JQL filter in order to see the number of incident( Open ticket ) created per week ( Monday to Monday)on the Jira service desk project. Let me know which query i can use to save it in the filter so that i do not have to change it every time, it should update in a way that every time i extract it on the excel it should update the latest week report.

2) Is there any way i can use cumulative graph for my Jira service desk project, or may be something similar.

Looking forward to hear soon for the help.

Thank you

Muhammad Bilal

Accepted answers

Tomas Gustavsson_mf0n45

Something like this?

project = xxxxxx and created < startOfWeek(-1)

please check
https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

All comments

Tomas Gustavsson_mf0n45

Something like this?

project = xxxxxx and created < startOfWeek(-1)

please check
https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

Muhammad Bilal_r2rxjd

Hi,

No, i just tried now, this is showing me the entire tickets created for the project,

I was using this before, Project = xyz AND created >= 2019-05-24 AND created <= 2019-05-31

But here i need to change every time the date manually, what i want is, it should fetch automatically per week and i go to the dashboard and can extract it to the excel sheet for the report.

Tomas Gustavsson_mf0n45

startOfWeek()

Perform searches based on the start of the current week. See For the startOfWeek() function, the result depends upon your locale. For example, in Europe, the first day of the week is generally considered to be Monday, while in the USA, it is considered to be Sunday.

Muhammad Bilal_r2rxjd

startOfWeek() does not work as well, it still shows me all the created request for the entire project.

Project = xyz AND created <startOfWeek()

Thank you

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-service-desk

jira-cloud