Understanding The Analytics Pages
The Analytics Pages exist to allow users to:
- Take an in-depth look at data within their event
- Create custom views in order to look at specific
- Download custom data exports
- Use tools to drill-down into data
Multiple data sets will have an Analytics page, data sets that currently have this feature are:
How do you use The Analytics Pages?
Adding And Removing Columns
The new feature allows you add or remove columns to allow you to see the exact data you want to see without needing to download it and manually reorder and delete columns.
On the right hand side of the table is a a popout menu that shows a list of all available columns. To see this you must have the 'Columns' tab selected and open, if you cannot see the area in the green rectangle on the image above, simply click the 'columns' tab again.
All of the columns that are currently displayed will have the boxes beside their name ticked, to add an additional column simply find the name of the column you would like to add, either by scrolling through the list or using the search function in this section.
Once a column has been added it will be added to the group in which it exists, for instance in the above example if I were to add 'Meeting Comment' this would be added in the 'Meeting Info' section of the table.
You can remove columns from the table by simply unticking them from the box on the right. You can also remove entire sections by unselecting them in this box too.
You can reorder columns within the table to either display data in a way that is most logical for you, order it in a specific way ahead of export, or to help with analysis.
To reorder a column hover over a column header until you see this reorder icon:
From here you can simply click and hold the header and drag it to where you want it to sit on the table.
If you move the column to a different section, it will create a label of the section it is part of above it, to avoid confusion:
As you can see in this example where I have moved Meeting ID into the 'Meeting Times' section, that it still has the 'Meeting Info' label above it.
In order to sort the table based on a column, simply click on the column header.
On first click the column header will display the up arrow and sort the column from smallest to largest for numbers, A-Z for words, and earliest to latest for dates.
On second click the column header will display the down arrow and sort the column from largest to smallest for numbers, Z-A for works, and latest to earliest for dates.
There are two ways of filtering on the table:
Using the column headers
Simply hover over a column header until you see this icon:
Simply click the icon and the the filtering menu will appear:
From here just choose from the options in the dropdown that best describes what you want to filter against:
- Contains - The data contains the value entered
- Not Contains - The data does not contain the value entered
- Equals - The data exactly matches the value entered
- Not Equal - The data does not match the value entered
- Starts With - The data begins with the value entered
- Ends With - The data ends with the value entered
You can choose two filters per column which can be added as either:
- AND - The data shown will match both filter values simultaneously
- OR - The data displayed will match one or both filter values
Using The Filters Tab
In addition to filtering using the column headers within the table, you can filter using the filters tab on the right hand side of the table.
This offers the same functionality as using the column header to filter, but also allows you to create filters for the table against columns that are not in the table.
Creating Pivot Tables
In order to create a pivot table, you must select the 'pivot mode' in the right hand box.
From there select the values you want to display in your pivot table from the columns list.
Select the row groups by dragging the desired columns to the 'Row Groups' section and choose the values that you want to add to the pivot table by dragging the values you want to display to the 'Values' section.
The key thing to remember about exporting data from the analytics page is that it will export the current view you have set within the table - so whatever columns, filters, ordering etc you have set in the table is how the export will appear.
You can also click 'Export all Columns' which will download a CSV file with all available data.