Visual Report Builder makes it easy to create quick reports based on predefined metrics. Each metric includes a query that defines the set of data for the report.
The following example shows how to create a simple report, group the data by an additional dimension, set the date and time interval, change the chart type, and save the report to a dashboard.
In the Commerce Intelligence menu, click Report Builder.
Under Visual Report Builder, click Create Report and do the following:
Click Add Metric.
The available metrics can be listed alphabetically or by table.
Choose the metric that describes the set of data that you want to use for the report.
New Customers metric used in this example counts all customers, and sorts the list by the date the customer signed up for an account. The initial report includes a simple line graph, followed by the table of data.
The summary on the left shows the name of the current metric, followed by the result of any calculations on column data that are specified in the metric. In this example, the summary displays the total customer count.
In the chart, hover over each data point on the line. Each data point shows the total number of new customers who signed up during that month.
Follow these instructions to group the data, change the date range, and chart type.
Group By control gives you the ability to add multiple dimensions by group or segment. Dimensions are columns in the table that can be used to group the data.
Choose one of the available dimensions from the list of
Group By options.
For this example, the system found five coupon codes that were used by customers while placing their first order.
Group By detail lists each coupon used by customers. The coupons that were used to place the initial order are marked with a checkbox. The chart now has multiple colored lines that represent each coupon that was used for a first order. The legend is color-coded to correspond to each row of data.
Click Apply to close the Group By detail.
Hover over a few data points on each line to see the number of customers during the month who used that coupon while placing their first order.
The table of data now has an addition dimension, with a column for each month, and a row for each coupon code.
Click the Transpose () control in the upper-right corner of the table to change the orientation of the data.
The axis of the data is flipped, and the table now has a column for each coupon code, and a row for each month. You might find this orientation easier to read.
Date Range control shows the current date range and time interval settings, and is located just above the chart to the right.
Date Range control, which in this example is set to
All-Time by Month.
Make the following changes:
Last Full Quarter.
Select Time Interval, choose
The report now includes only the data for the last quarter, by week.
Click the controls in the upper-right corner to find the best chart for the data.
Some chart types are not compatible with multidimensional data.
|Horizontal Stacked Bar|
|Vertical Stacked Bar|
To give the report a
title, replace the
Untitled Report text at the top of the page with a descriptive title.
In the upper-right corner, Click Save and do the following:
Type, accept the default setting,
Dashboard where the report is to be available.
Click Save to Dashboard.
To view the chart in a dashboard, do one of the following:
Click Go to Dashboard in the message at the top of the page.
In the menu, choose
Dashboards and click the name of the current dashboard to display the list. Then, click the name of the dashboard where the report was saved.