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 [2023/01/27 14:40] – [Step 2: Update The Ticket Files] 10.91.110.100 | 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 12: | Line 14: | ||
| __**Internal Tickets (Jira)**__ | __**Internal Tickets (Jira)**__ | ||
| - | Bookmark this Jira filter | + | Bookmark this Jira filter. Export it with the " |
| [[https:// | [[https:// | ||
| Line 19: | Line 21: | ||
| ===== Step 2: Update The Ticket Files ===== | ===== Step 2: Update The Ticket Files ===== | ||
| - | [[https:// | + | [[https:// |
| * Update the 2 Ticket google sheets located in the Ticket File folder with the data from their corresponding report. | * 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, select yes when prompted. | + | * Each Sheet will autorun a Macro that will clear the sheet of last week's data, you must select yes when prompted |
| * 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. | * 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 |
| - | + | ||
| - | + | ||
| - | * Open the Weekly Report Google Sheet. ( Important to only open report at this point ) | + | |
| - | + | ||
| - | * The report | + | |
| - | + | ||
| - | * Wait for the report to finish. | + | |
| - | + | ||
| - | * The Report will send itself | + | |
| - | + | ||
| - | ===== Step 4: Update ExteNet Slides ===== | + | |
| - | + | ||
| - | + | ||
| - | On the ExteNet [[https:// | + | |
| - | + | ||
| - | Check the Awaiting Response slide, this will have the labels in the first column updated based on the contents of the latest update field. | + | |
| - | + | ||
| - | If the " | + | |
| - | + | ||
| - | * Add a number 1 to the Filter column for any ticket that is awaiting ExteNet to verify something. | + | |
| - | + | ||
| - | * Add a number 2 to the Filter column for any ticket that is awaiting information from ExteNet. | + | |
| - | + | ||
| - | * Select “Sort”. | + | |
| - | Go back to the slide and update. | ||
| - | Inform Anthony that the slides are updated. | ||
support/weekly_reports.1674830417.txt.gz · Last modified: 2023/01/27 14:40 by 10.91.110.100
Page Tools
