User Tools

Site Tools


support:weekly_reports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
support:weekly_reports [2023/06/21 12:43] 10.91.129.7support:weekly_reports [2023/11/07 14:40] (current) – [Step 1: Export Ticket Data] 10.91.120.100
Line 4: Line 4:
  
  
-https://drive.google.com/drive/u/0/folders/1R_EqMTBgzt4kEx-TStLpCx2KmvXDWZAi+ 
  
 ===== Step 1: Export Ticket Data ===== ===== Step 1: Export Ticket Data =====
Line 14: Line 14:
 __**Internal Tickets (Jira)**__ __**Internal Tickets (Jira)**__
  
-Bookmark this Jira filter+Bookmark this Jira filter. Export it with the "filter fields" option
  
 [[https://errigal.atlassian.net/issues/?filter=18199|Weekly Report All Internal Tickets ( 2 weeks of Resolved/Closed)]] [[https://errigal.atlassian.net/issues/?filter=18199|Weekly Report All Internal Tickets ( 2 weeks of Resolved/Closed)]]
Line 21: Line 21:
 ===== Step 2: Update The Ticket Files ===== ===== Step 2: Update The Ticket Files =====
  
-[[https://drive.google.com/drive/u/0/folders/1R_EqMTBgzt4kEx-TStLpCx2KmvXDWZAi|Ticket Files Folder]]+[[https://drive.google.com/drive/u/0/folders/1R_EqMTBgzt4kEx-TStLpCx2KmvXDWZAi|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.   * 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 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.   * 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.
support/weekly_reports.1687347837.txt.gz · Last modified: 2023/06/21 12:43 by 10.91.129.7