User Tools
support:weekly_reports
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| support:weekly_reports [2021/07/08 17:24] – [Step 1: Export Ticket Data] 10.5.5.89 | support:weekly_reports [2023/11/07 14:40] (current) – [Step 1: Export Ticket Data] 10.91.120.100 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======How To Run The Weekly Report====== | ======How To Run The Weekly Report====== | ||
| - | [[https:// | + | [[https:// |
| + | |||
| ===== Step 1: Export Ticket Data ===== | ===== Step 1: Export Ticket Data ===== | ||
| Line 9: | Line 10: | ||
| __**ScottyPro Tickets**__ | __**ScottyPro Tickets**__ | ||
| - | For all currently open tickets | + | In the ScottyPro Reporting Manager |
| - | + | ||
| - | For all the tickets | + | |
| __**Internal Tickets (Jira)**__ | __**Internal Tickets (Jira)**__ | ||
| - | Book mark the below Jira filters | + | Bookmark this Jira filter. Export it with the " |
| - | [[https:// | + | [[https:// |
| - | [[https:// | + | |
| + | ===== Step 2: Update The Ticket Files ===== | ||
| - | [[https://errigal.atlassian.net/issues/? | + | [[https://drive.google.com/drive/u/0/ |
| - | + | ||
| - | ===== Step 2: Update The Ticket Files ===== | + | |
| - | [[https:// | + | * Update the 2 Ticket |
| + | * 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. | ||
| + | |||
| - | ===== Step 3: Run Report ===== | + | 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 |
| - | ===== Step 4: Update ExteNet Slides ===== | ||
support/weekly_reports.1625761497.txt.gz · Last modified: 2021/07/08 17:24 by 10.5.5.89
Page Tools
