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. Export it with the “filter fields” option

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