Formulas

In the menu, choose Report Builder.

Click Add Metric and choose the first metric for the report.

For this example, the Revenue by products ordered metric is used.

Click Add Metric again and choose the second metric for the report.

For this example, the New Customers metric is used.

In the sidebar, click Details to display information about each metric.

In the sidebar, click the name of each metric to open the settings page in a new browser tab. Scroll down to see each component of the metric, including the metric query, filter, and dimensions.

To return to your report, click the previous browser tab.

In the chart, hover over a few data points on each line to see the amounts associated with each metric.

At the top of the sidebar, click Add Formula.

The formula box shows the metrics as available inputs A and B, and includes an input box where you can enter the formula.

Do the following:

• In the Enter your Formula input box, enter A/B.

  This divides the revenue by products ordered by the number of new customers.

• Set Select format to 123Number.

• In the sidebar, replace Untitled with a name for the formula.

When complete, click Apply.

The report now has a new line for the formula, New Customer Revenue, and the sidebar shows the total amount of revenue generated by new customers.

Click Date Range in the upper-right corner.

On the Fixed Date Range tab, do the following:

• On the calendars, choose the date range.

  For this example, the holiday season is from November 1 through December 31.

• Under Select Time Interval, choose Day.

  

• When complete, click Apply.

The report is now limited to the holiday season, with a data point for each day.

Click Untitled Report at the top of the page and enter a descriptive title. For this example, the report title is 2017 Holiday Sales.

Then, do the following:

• In the upper-right corner, Click Save.

• For Type, accept the default Chart setting.

• Choose the Dashboard where the report is to be available.

• Click Save to Dashboard.

Click the report title and change the name. For this example, the report title is changed to 2017 Holiday Sales Data.

Then, do the following:

• In the upper-right corner, click Save a Copy.

• Set Type to Table.

• Choose the Dashboard where the report is to be available.

• Click Save a Copy to Dashboard.

To see the reports in your dashboard, do one of the following:

• Click Go to Dashboard in the message at the top of the page.

• In the menu, choose Dashboards. Click the name of the current dashboard to display the list. Then, click the name of the dashboard where the report was saved.