Hi,
In Confluence I'm trying to use a Jira Filter to display a table of the last 7 days of Service Management closed tickets..... by date and by Request type (a custom field).
I can get the custom field to be on Y axis but I cannot get the resolutiondate / resolved field on either the X or Y Axis.
Why can't the resolution date be used ?
project = IDYOUS AND STATUS = Resolved AND resolutiondate >= -7d AND "Service Desk Customer Type[Dropdown]" != XYZ ORDER BY KEY ASC
Here is a mock up of what I'm trying to achieve:
Support Request x | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Total |
| 20/06/2022 | 21/06/2022 | 22/06/2022 | 23/06/2022 | 24/06/2022 | 25/06/2022 | |
Password reset | 4 | 5 | 4 | 5 | | | 18 |
Set Up New account | 10 | 6 | 10 | 12 | | | 38 |
How to use IDyou | 4 | | | | | | 4 |
Video call – Connection issues | 1 | | | | | | 1 |
Video Call - Activate Camera/microphone | | 1 | | | | | 1 |
Edit Account details | 3 | | | | | | 3 |
Code not received | | 1 | 1 | | | | 2 |
Edit Details of VOI | | | | | | | |
Login/Access Issue | | | | | | | |
Still Waiting on Docs after uploading | | | | | | | |
White Screen/Blank screen | | | | | | | |
Data/Face mismatch errors | | | | | | | |
Issues with VOI report/processing | 1 | | 1 | | | | 2 |
Types of documents to be used | | | 1 | | | | 1 |
Still trying to using App | | | | | | | |
Sales Queries | 1 | | | 1 | | | 2 |
Validity of VOI report | | | | | | | |
Emails from borrowers to IDyou Inbox | | | 3 | | | | 3 |
Concerned about spam | | | | | | | |
Total | 24 | 13 | 20 | 18 | | | 75 |
