Visual Report Builder
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.
To create a simple report:
-
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.
The
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
The
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.
The
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
The
Date Range
control shows the current date range and time interval settings, and is located just above the chart to the right.-
Click the
Date Range
control, which in this example is set toAll-Time by Month
. -
Make the following changes:
- To zoom in for a closer view, change the date range to
Last Full Quarter
. - Under
Select Time Interval
, chooseWeek
. - When complete, click Save.
The report now includes only the data for the last quarter, by week.
- To zoom in for a closer view, change the date range to
Chart Type
-
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.
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 8-row-2 layout-auto Line graph Horizontal Bar Horizontal Stacked Bar Vertical Bar Vertical Stacked Bar Pie Area Funnel
-
-
To give the report a
title
, replace theUntitled Report
text at the top of the page with a descriptive title. -
In the upper-right corner, Click Save and do the following:
-
For
Type
, accept the default setting,Chart
. -
Choose the
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.
-