...
Exact JQL: project in ("IT Service Desk","PSU Support Desk","TC Service Desk","Agent Support Desk","Faculty Support Desk") AND "Support Team[Select List (cascading)]" in ("OIT") AND issuetype in("Incident","Service Request","Service Request with Approvals","Service Request with Approvals - All Required") AND resolved >= 2022-10-01 AND resolved < 2023-10-01
Execute the JQL search query above, then click on “1000+” below results to “See the total number of issues.”
...
Exact JQL: project in ("IT Service Desk","PSU Support Desk","TC Service Desk","Agent Support Desk","Faculty Support Desk") AND "Support Team[Select List (cascading)]" in ("OIT") AND issuetype in("Incident","Service Request","Service Request with Approvals","Service Request with Approvals - All Required") AND resolved >= 2022-10-01 AND resolved < 2023-10-01 AND Satisfaction IS NOT EMPTY (same as above, with the added final clause)
Execute the JQL search query above, making sure that Satisfaction is one of your visible columns. Select Apps > Open in Microsoft Excel to download all search results (not just the single screen of results you get using Export issues). Open the exported file in Excel. Highlight all Satisfaction values and correct error with “Convert to Number”. Format the Satisfaction values as Number with 2 decimal places. Highlight entire Satisfaction column to see Average in lower right corner of application window.
...
Exact JQL: project ="OIT Project Portfolio" AND status=Done AND due >= 2022-10-01 AND due < 2023-10-01
Procedure: Execute and query, note count below results.
...
Exact JQL: project="Technical Service Desk" AND issuetype="Change" AND status="Resolved" AND "Change Start Date" >= 2022-10-01 AND "Change Start Date" < 2023-10-01
Procedure: Execute and query, note count below results.
...