User Tools
support:weekly_reports
This is an old revision of the document!
Table of Contents
How To Run The Weekly Report
Step 1: Export Ticket Data
ScottyPro Tickets
In the ScottyPro Reporting Manager run the Weekly Reports - All Support Tickets this will return all ScottyPro tickets required for the report.
Internal Tickets (Jira)
Bookmark this Jira filter
Weekly Report All Internal Tickets ( 2 weeks of Resolved/Closed)
Step 2: Update The Ticket Files
Ticket Files Folder and How to docs
- Update the 2 Ticket google sheets located in the Ticket File folder with the data from their corresponding report.
- Each Sheet will autorun a Macro that will clear the sheet of last week's data, you must select yes when prompted as this will also date stamp the sheet.
- Paste in data from the report into cell A1. Before pasting make sure that all columns with hash symbols are adjusted so data is visible.
The report is set on a schedule and will run itself between 1pm and 2pm, if I can't run for some reason an email will be sent to support@errigal.com
support/weekly_reports.1687441745.txt.gz · Last modified: 2023/06/22 14:49 by 10.91.129.7