How to get total count of tickets in project queue?

[Terrance Bennett]

Using as a search string the last Friday to current or coming Friday?

Not wanting to use last 7days (project = SEC AND created >= -7d ) need to use calendar friday to friday.

thanks in advance

[Gregory Van Den Ham · Accepted solution]

how about something like:

created >= endOfWeek(-1) AND created <= endOfWeek() ORDER BY created ASC

There's also the startOfWeek JQL that will get you the Monday, likely dependent on how you have Jira setup.

[Terrance Bennett]

Thanks were able to use the date by, thanks to Norman Weekes

project = NNAME AND created >= "2018-09-14" AND created <= "2018-09-21"

[Gregory Van Den Ham]

Awesome, one way has a static date and the other has a dynamic that you can save as query and dashboard.

Either way works though ;)

[Norman Weekes · Accepted solution]

Can also do:

project = SEC AND created >= "2018-09-14" AND created <= "2018-09-21"