Exclude Weekends in Query

[Choo Kai Min Bryan]

My workplace uses Jira to track patients. We have an excel sheet to be updated daily to have a daily report to provide statistics of which colleague can take up a patient.

Currently the query searches the amount of issues assigned to them from 365 days to now. It has come to my attention that the report would not be accurate as it calculates the weekends too. We work on weekdays only and this report could be providing false information for us. As we might be assigning more issues to some colleagues than should.

The report is collected from the total issues to each jira users assigned in the past 365 days to now. It would be taken to an excel sheet with certain calculations to get a report of colleagues who can take up a patient.

I know there are some questions left unanswered for it. But I hope there might be some sort of method to track issues created 365 days till now - all the weekends

If not could I kindly request how other ways we can try to find ways on how your workplace manages to find out how issues should be assigned in a fair manner ? We can try to integrate them in our office. I really appreciate your help!

[Peter Bengov]

I would add your vote to https://jira.atlassian.com/browse/JRASERVER-27539 in order to push this feature forward 

[Choo Kai Min Bryan]

Haha thanks Peter. I have added my vote to it. But it won't be anytime soon won't it 

[Peter Bengov]

Thanks for sure, unfortunately 

[Tom Lister]

Hi @Choo Kai Min Bryan

This may be an issue in the way your excel is performing the calculation. JIRA will only return dates for issues created. Or did you want to exclude issues that have actually been created on weekends?

For info, I have used Scriptrunner to create scripted fields that parse dates for reporting i.e. convert to formats like Q1, Q2 etc and can be used to return a day of the week you could use in your JQL query.

There are other plugins that also provide  smart/script fields.

[Choo Kai Min Bryan]

Sorry I must have phrased it very confusingly. Thank you for your suggestions. To clarify , we would like to find issues only created on weekdays from 365 days ago. 

Because our excel file will have certain calculations for loads for each user to allow us to know who should be assigned an issue. This excel file gets updated daily except weekends.

But it was noticed by one of our colleagues that some days the loads would be constant. We looked into this where we realized because weekends were counted too. Because on that day it was updated it was a Sunday 365 days ago. Therefore the conclusion that the day before , when he updated it , it was a Saturday 365 days ago. Therefore producing the same load. 

To prevent this from happening , we thought to find to exclude the weekends.