I need a query that finds issue types created on business days only

Question

Our business model is 365 days, but i need to find how many project epics are created on weekends. Since it doesnt look like i can do this expression, instead, how do i find created dates (or created) for epics on mon - fri only. Then I will just take the difference.

To be clear, I want to be able to produce this number on a monthly and annual basis

I am running jira cloud fully current

BrentBot · Answer

Thank you, So to get the full year I would have to do this for 52 weeks? I dont even know if that is possible. how would i do that by week

Pramodh M · Answer

Hi @BrentBot

Currently, the way to search for created issues is taking each week's date and searching it via JQL

Here it is for the current week

created >= startOfWeek("+1d")

For previous weeks created an issue

created >= startOfWeek("-6d") AND created <= endOfWeek("-1d")

For excluding the issue exclusively by default, there is a feature request

https://jira.atlassian.com/browse/JRACLOUD-22506

Thanks,
Pramodh