This article will help you to:
- Use the advanced Widget editing mode
- Manipulate Columns and Column Sets
- Leverage Metrics and Dimensions
Using the advanced Widget editing mode
First, double-click a Data Widget to access the advanced editing mode. There, you’ll see that all Data Widget follow a table structure where columns are Metrics and rows are Dimensions.
Manipulating Columns and Column Sets
A Column Set is a group of Columns and Columns can be Metrics or a custom Metrics (also known as calculated Metrics or Relations).
By default, the Column Set inherits the Data Input from the Widget and the Column inherits the Data Input from the Column Set but note that you can overwrite these settings.
You can have a Data Widget where a Column’s Date Range is set “Current Year” while another Column of that same Widget is set to “Last Year”.
Leveraging Metrics and Dimensions
There are three types of Metrics:
- Metric: Metric from your Data Source (e.g., “Returning Visitor” from Google Analytics)
- Relation: Relation based on one or several Column(s)
- Calculated Metric: Metric calculated at the dataset level (whereas Relation metrics are calculated at the widget level based on columns). Once created at the dataset level, these are readily available along with your usual Metrics.
Relation Metric Example
If you want to get the quarter of Column A, simply create a new Column and set the Metric type to “Rel”.
In the Relation field, input “A/4”. After validation the results will be displayed on the new Column.
To access a list of calculated fomulas, like the Average or the Minimum for example, already in Reeport, click on the Formula button
To learn more about calculated formulas, please read the article Calculated Formulas.
Among the advanced features, it is possible to hide Columns. By hiding a Column, the data won’t be displayed on the Widget. This feature is available on the option panel on the “Display” tab or on the Column dropdown options.
Dimensions are a great way to slice and dice your data, they apply to Metrics and can be set to:
- No Dimension: all the data for your Metric(s) is thus aggregated on one single row
- From API: Dimensions as is from the Data Source (e.g., using the “deviceCategory” Dimension from Google Analytics would distribute your data across “desktop”, “mobile”, and “tablet”)
- Custom: Custom Dimension create on the go right from Reeport. Custom Dimensions give you retroactive flexibility as to how you can distribute your data. For more informations please visit Custom Dimensions overview.
Note that you can also apply Conditions (Filters, Segments, etc) to Column Sets and Columns in order to fetch more or less specific data.