Magento Business Intelligence Help Center

Using the Visual Report Builder

BROUGHT TO YOU BY

Avatar

The Visual Report Builder is, as the cliche goes, where all the magic happens. Now that you have all your data living under the same roof, it’s time to explore it and draw some insights. In this article we’ll walk you through the process of creating a basic report. After you’ve learned your way around, check out our analysis library for some tips and inspiration.

Remember: to add a report to a dashboard, you need Standard user permissions and Edit access to the dashboard.

Here’s what’s involved in creating an analysis in the Visual Report Builder:

  1. Add metrics
  2. Add formulas
  3. Set time period and interval of analysis
  4. Group by / segment your analysis
  5. Set metric filters, perspective and time interval
  6. Save

To get started creating a new report, click Report Builder on the sidebar or the Add Report button at the top of any dashboard. When the Report Builder selection page displays, click the Visual Report Builder option.

To edit a report created in the Visual Report Builder, click the gear (Options) icon in the top right corner of any chart, then click Edit.

Let’s get started!

Adding metrics

The first step in creating an analysis is selecting the metric to analyze. While the metrics are listed alphabetically by default, you can also group them by Table (i.e. the data table that powers the metric).

Additional metrics can be added after the initial metric is selected. You can overlay all the metrics on a single report or perform multi-metric calculations using the Formula feature.

Adding formulas

Formulas are added to reports by clicking the Add Formula button, located just above the list of metrics in the report. In the formula editor, any of the metrics included in the report can be used as inputs. Basic mathematical operators are used to manipulate the different metrics.

Let’s say we wanted to create a report that shows us the average revenue per order. In this case, we’d divide the Revenue metric by the Number of orders metric.

Setting the time period and interval of analysis

To zero in on a particular stretch of time, you can set the time period for the analysis. You can also choose time intervals to segment the data (ex: by year, quarter, month, etc). Use the menus in the top right corner of the chart to set the time period and interval.

When setting a specific date range for the time period, make sure the start date is at the beginning of the interval and the end date is at the end of your interval.

For example, setting a time period from January 1st to March 1st and choosing a monthly interval will show March as a datapoint, but ignore every day in March except March 1st. In that case, you should make your Time Period from January 1st to March 31st.

Group by / segmenting the analysis

To segment your metrics by a data dimension, click the Group by menu at the top left of the chart. This will reveal a drop-down including all available dimensions of the first metric included in the list.

You can choose None to prevent a metric from being segmented. For example, you might want a metric that returns total revenue without being segmented, while having another revenue metric segmented by region.

Let’s go back to our average revenue per order example and set the Group by to promo code. This will show us the average revenue per order for orders both with and without a promo code.

If the metrics included in the analysis are built on different data tables, a pop-up will allow you to select the matching data dimension in each table. The goal here is to find dimensions that share the same type of values for segmentation:

Setting metric filters, perspective, and time interval

For each metric added to the analysis, you can add filters, select the relevant data perspective, and set time interval options. To access these features, click the funnel (Filter), eye (Perspective), and clock (Time) icons located next to the metrics included in the report.

Filters

Filters limit the dataset included in the analysis. Filters are extremely handy, for example, when evaluating individual acquisition channels and removing outliers.

In addition to the dropdown menus and text box, you can also use special filter operators such as LIKE or IN to create filters.

The use of wildcards (% or _) in conjunction with LIKE statements is supported. The % wildcard will match multiple characters, while _ will only match any single character. For example:

  • affiliate's name Like B% will only allow data from customers whose name starts with B
  • affiliate's name Like _ake will only allow data from customers whose names are something like "Jake," "Rake," or "Bake" but not "Drake" or "Blake"

Adding multiple filters allows tight control of the chart’s data. By default, all filter conditions must be true for a piece of data to be included, but you can create OR relationships by editing the Filter Rules text box.

Perspectives

Perspectives allow you to easily toggle between different views of your data. Let’s take a look at what’s available:

Standard perspective

The standard perspective shows you the result for the matching date on the x-axis (e.g. revenue in January). This is the perspective we’re using in our Average revenue per orders example.

Amount OR Percent Change vs Previous Period perspective

This perspective shows the amount or percent change from one interval to the next and is useful for measuring the rate of change in fast-changing metrics.There is also a perspective to compare the interval to the same time period last year to show year over year growth.

Cumulative perspective

The cumulative perspective shows the ongoing or cumulative sum amount of the metric over the time period. This is often used to analyze total customers and plan for future capacity.

Percent of First Value perspective

This perspective shows the data as a percentage of the first time interval included in the analysis. This is helpful in measuring the effectiveness of specific actions relative to the first period performance.

Metric-specific time options

Want to learn more about how to use Time Options in your reports? Check out this tutorial for some in-depth examples!

Two options exist for metrics used in reports: they can trend over time according to the global time options, or not, which will display them as a scalar number.

Changing a metric’s time interval to None will return a scalar number, which is useful when creating formulas that involve dividing a time-trending metric by a scalar number. Additionally, you can also change the time range of the scalar metric to a time range independent of that for the report. There can be a maximum of two distinct time ranges in any one report.

Let’s say, for example, we wanted to see 2014 monthly revenue expressed as a percentage of overall 2014 revenue. We can add two Revenue metrics to a report with a global time range of January 1st 2014 to December 31 2014, segmented by monthly interval.

Saving the report

When you create a new chart, you can save it by clicking the Save button at the top right corner of the Visual Report Builder.

You can choose to save a chart, table, or number (scalar) using the Type dropdown and the dashboard to which the report should be saved using the Location dropdown.

You can then save the report by clicking the Save to Dashboard button.

Report outputs

Want to know what each output will look like before you choose one? Take a look:

Chart

Table

Number (scalar)

That’s it! Now that you’ve gotten familiar with the Visual Report Builder, check out our analysis library for some inspiration.

Related:

Was this article helpful?
1 out of 2 found this helpful

Comments

  • Avatar
    Greg Whelan

    Perspective is lacking "use" detail, an actual example of how to configure a week vs week comparison.

    I use a Mon-Sun week and I know the RJ default is Sun-Sat...I had the global setting changed but am unclear if that matters for the Amount vs Previous Period logic?

  • Avatar
    Erin Cochran

    Hey Greg!

    That's a great question. For this perspective, it will obey whatever you have the global week start parameter set to. In your case, it will respect Monday as the week start and Sunday as the week end.

    So, when using this perspective with a weekly interval in your reports, you can expect to see the start as a Monday.

    I hope this clears up any confusion. I'm going to add a note about this to the article - thanks for the great question!

    Erin

Powered by Zendesk