How to pivot a usage report (by user) 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 user
6. Select all data in raw data tab, insert pivot table. Select Fields as shown:
7. To calculate % of queries run as Identity Check, add this formula to cell K5: =SUM(F5:G5)/J5
- Fill down
8. Add conditional formatting as desired
- In this case, Data Bars were added to column J and Color Scale was added to Column K
Comments
0 comments
Article is closed for comments.