Hello Team,
1. How to get data for True Creation Date - (minus) First Response through JQL
2. I am trying to create a dashboard with shiftwise data. We had tried but unable to set the timing for shift wise.
The requirement is how many tickets were created between 4:30 am to 1:00 pm and how many tickets were created between 12:30 pm to 9:00 pm and how many tickets were created between 8:30 pm to 5:00 am.
suppose i use created >= "2022/11/28 04:30" and created <= "2022/11/28 12:30"
and create three filters separately, I need to amend the changes every month in jql ?
Also, if i create using your query then it's not giving actual correct data for shift wise.
For ex. I tried with project = XYZ AND issuetype = Support AND created >= "2022/11/01 04:30" AND created <= "2022/11/30 13:00" AND assignee in (**, **, ***) it's giving me afternoon ticket data count instead of morning ticket data count
Best Regards,
Nilesh
Hello @nilesh.shah
The second ask, create a dashboard with shift-wise data, is clear. This can be fulfilled in a below manner:
Kindly share more details on the first requirement.
Please accept the answer if this helps.
--GG
@Gaurav
For first one - I am creating report for actual time spent between True Creation Date - (minus) First Response through JQL how do i do that through JQL?
For second : I tried with project = XYZ AND issuetype = Support AND created >= "2022/11/01 04:30" AND created <= "2022/11/30 13:00" AND assignee in (**, **, ***) it's giving me afternoon ticket data count instead of morning ticket data count
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @nilesh.shah
For the second, please refer to the solution suggested previously.
For the first, you would need either a plugin to perform the calculation or use a process similar to the option for the second. Create a custom field, update the same using the Automation Rule and then utilize it as required.
The calculation cannot be performed in JQL.
Hope this helps.
--GG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.