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.
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.
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.