Visualize Data with Analytics

  2. Home
  4. Docs
  6. Visualize Data with Analytics
  8. Visualize
  10. Pivot Table

Pivot Table

Use the pivot table to summarize data statistics in table format

  1. Select your preferred dataset in the right-hand side panel
  2. Select which data values you want to be represented on the Rows
  3. Select which data values you want to be represented on the Columns
  4. Select which data values you want to be represented in the Aggregation Field
  5. Select which Aggregation you want to be applied to the above Aggregation Field (i.e. count, average, sum, minimum or maximum)
  6. Use the +Add filter feature to add more filters to your pivot table.

8 STEPS

1. The first step is to select a dataset

Step 1 image

2. Click Pivot Table

Step 2 image

3. Select which response field you want to be represented on the Rows

Step 3 image

4. Select which response fields you want to be represented on the Columns

Step 4 image

5. Select which data value you want to aggregate in the Aggregation Field

Step 5 image

6. Click Count

Step 6 image

7. Select which Aggregation function you want applied to the above Aggregation Field (i.e. count, average, sum, minimum or maximum)

Step 7 image

8. That’s it. You’re done.

Step 8 image

Here’s an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/1945810/Analytics-Esoko—How-to-visualize-a-Pivot-Table

Was this article helpful to you? Yes No