Advanced Widget

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.

Example

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

Metrics

There are two types of Metrics:

  • Metric: Metric from your Data Source (e.g., “Returning Visitor” from Google Analytics)
  • Relation (aka custom or calculated Metric): Relation based on one or several Column(s).
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.

Hidden Columns

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.

Example: You want to create a Table Widget where the first Column is the Revenue in February and the second Column is the variation rate versus January. From the advanced Widgets settings: Column A = Metric set to Revenue in February ; Column B = Metric set to Revenue in January ; Column C = Relation set to (A-B)/B. Hide Column B and you’re done!

Dimensions

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

Note that you can also apply Conditions (Filters, Segments, etc) to Column Sets and Columns in order to fetch more or less specific data.

Updated on October 17, 2018

Was this article helpful?

Related Articles