This article will help you to:

  • Hide a metric and/or a dimension
  • Rename metrics and/or dimensions
  • Bookmark a metric and/or a dimension
  • Create a calculated metric at the Dataset level
  • Change aggregation and type of metrics

What is "Manage dataset"?

Once your data source is connected, you can customize the metrics and dimensions of your dataset with "Manage dataset".

Go to "Manage dataset"

In the "Data Source" tab, select the desired data source and click on "Manage dataset".

You can then customize all the metrics and dimensions at your disposal.

What are the functionalities at your disposal?

Rename a metric and/or a dimension

To do this, select the desired metric or dimension and then change its name in the space provided.

How to hide a metric and/or dimension

Select the desired metric and/or dimension and then click on the eye nearby (1).

Thus, from the Builder mode, you will only have access to the metrics and/or dimensions relevant to your project and your reading will be facilitated.

Bookmark a metric and/or a dimension

Select the desired metric and/or dimension and then click on the star nearby.

This method is very useful to quickly access these elements in Builder mode. Indeed, when you bookmark a metric or a dimension, they appear first and save you precious time!

Create a calculated metric

Some of the metrics you use are not available natively although they are essential for your reports. You can create these metrics automatically on Reeport.

To do so, you can do the following:

  • Click on "create calculated metric"
  • Enter the desired formula in the box provided. Please note that your formula is written from the metric IDs. In addition, each metric must follow the following syntax: {{metric ID}}. Note that you can enter the first letters of the metric you want to use and Reeport will highlight the corresponding metrics to make it easier for you.

Don't forget to name your metric as desired. It will then be available in Builder mode under the given name.

Modify the aggregation of metrics and dimensions in the case of a database connection or flat file integration

This feature is particularly useful if you want to change the aggregation of your data to meet your reporting needs. The following types of aggregation are available:

  • Sum: Reeport adds up each line of the relevant metric
  • Mean: Reeport is the average of each line of the metric concerned.
  • Count: Reeport counts the number of lines of the metric in question.
  • Distinct: Reeport makes a single count of the metric concerned.
  • Min: Reeport returns the minimum value of the metric concerned
  • Max: Reeport returns the maximum value of the metric concerned

You can also change the type of your metric and dimension according to your needs and switch from one to the other if you wish.

Did this answer your question?