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