Preparing data for pivoting

1. Request csv report for desired month—information on how to to obtain a csv report can be found here

2. Open attachment in Excel

3. Insert column between columns A and B

4. Select column A. Click Data>Text to Columns

• Select Delimited, click Next >
• Check Space, click Next >, and then Finish

5. Delete column B

Pivoting queries by week

6. Select all data, insert pivot table. Select Fields as shown:

7. Right click the date heading in cell B4, select Group…

• Confirm the range of dates desired with Starting at and Ending at dates
• Under By… select Days
• For Number of Days type 7, then click OK

8. Sort the report by most active users by clicking the filter arrow in cell A4

• Select Descending and
• Sort by Count of User