Convert dimensions to metrics in custom reports

In custom reports, you can choose metrics to create a report. Basic metrics are listed in the metric picker, but you can also convert a dimension to a metric. For example, a dimension session time can be converted to a metric average session time.

To convert a dimension to a metric, follow these steps:

  1. Go to Menu > Analytics (new).
  2. Navigate to Custom reports.
  3. Create a new custom report.
  4. While setting up a report, add a dimension to the report.
  5. Click the dimension and pick the metric to which you want to convert the dimension.
  6. Convert a dimension into a metric in custom reports.

    Tip: Dimensions are green and metrics are blue. When you change a dimension to a metric it will change from green to blue.

  7. Repeat this process for other dimensions and finish creating the report.

Tip: In the explorer report, drag and drop dimensions to the table, not to the dimension section because you’ll be converting it to a metric.

Extract or group dimensions differently

Some dimensions can be extracted to a simpler form, for example, a dimension page URL can be extracted to page URL (path). Or they can be grouped in a different way, for example, a dimension date (group by day) can be grouped by a day of the week.

To extract a dimension or group it differently, follow these steps:

  1. Go to Menu > Analytics (new).
  2. Navigate to Custom reports.
  3. Create a new custom report.
  4. While setting up a report, add a dimension to the report.
  5. Click the dimension and pick the extract or grouping that you need.
  6. Repeat this process for other dimensions and finish creating the report.
Was this article helpful?

Be the first to rate this article.

Technical Support

If you have any questions, drop us a line at support_SPC@piwik_SPC.pro.

We’re happy to help!