Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Click the + (new sheet) tab at the bottom of the workbook to create a new sheet.
  2. Right-click the new sheet tab and name it Requests. All the GROUP functions operate on this sheet.
  3. Group by email address and group by status code.  Click the first column of the new sheet (Requests) to display the Formula Builder (As of Datameer v6.4, click the Click the  Fx  button on the formula line to display the formula builder ) and set up a formula of GROUPBY() email address. (As of Datameer 7.2, the formula builder is located in the worksheet inspector.)
  4. Select the function GROUPBY and then click in the Email column from your joined sheet.
  5.  On the Requests sheet, the data is grouped by email addresses.
  6. Then group by Status code using the same procedure. This shows the email addresses grouped by status codes.
  7. Next you use GROUPSUM function. Click the third column of the Requests sheet and do a GROUPSUM of bytes sent from your joined sheet.
  8. Click the fourth column on the Requests sheet and use the GROUPCOUNT function.
  9. From the Data menu, select Filter, and apply a filter of status code = 200 (successful web request to view page).
  10. Click Create Filter.

...