How to pivot a usage report (by week) Follow
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
Comments
0 comments
Please sign in to leave a comment.