To create a summary report for a specific week, follow these steps.

  1. Open the most recent weekly summary report. As an example, you can follow the steps using Doc Status 2017/11/6.
  2. Select the ... "more" icon, and then select Copy.
  3. Update the title to remove Copy of and change to the Monday date. 
  4. In the first section (the summary table), there is an Excerpt macro. This macro is inserted into the Scrum of Scrums weekly status page. 
  5. In the Merged section, update the date to the Monday date.
  6. Click the gray report macro, and then select Edit.
  7. Change the dates in the filter by adding 7 days to the previous dates listed. This equates to using the Sunday date directly prior to the Monday report date, and the week ending Saturday date. In the example, using the Doc Status page from 6 November 2017, the dates would change as such: 

    (labels = doc_team OR project = DOC) AND issuetype in (Bug, Story) AND status = Merged AND resolved >= 2017-11-5 AND resolved <= 2017-11-11

  8. Select the magnifying glass icon. This updates the list of stories and bugs that match the filter. (If you forget to select this icon, the changes you make will not be saved.)

  9. Select Insert.

  10. In the In Progress section, update the date to the Monday date.
  11. Click the gray report macro, then select Edit.
  12. Change the dates in the filter as directed in step 6.  (example of date filter below. Note there are three locations that need to be updated)

    (labels = doc_team OR project = DOC) AND issuetype in (Bug, Story) AND Status != "Merged"  AND Status != "Closed"  AND Status != "Ready for Work" AND (((STATUS WAS "In Progress" AFTER "2017-11-5") AND (STATUS WAS "In Progress" BEFORE "2017-11-11")) or ((STATUS WAS "In Review" AFTER "2017-11-5")) AND ((STATUS WAS "In Review" BEFORE "2017-11-11") or (STATUS WAS "In Revision" AFTER "2017-11-5")) AND ((STATUS WAS "In Revision" BEFORE "2017-11-11")))


    Note: You cannot view the entire filter from the form field. To make editing the filter easier, you can copy the filter code into a text file, make the needed date changes, and copy the edited filter code back into the form field. Alternatively, you can place the cursor in the field and use the arrow keys to navigate the text to find the three dates that you need to update.

  13. Select the magnifying glass icon. This updates the list of stories and bugs that match the filter. (If you forget to select this icon, the changes you make will not be saved.)

  14. Select Insert.

  15. Select Save.

  16. Request that the doc team members update the summary table at the top of the page to reflect the week's work in progress and completed work. This summary table gets included each week in the Scrum of Scrum report via an Excerpt Include macro.