Documentation Home »User Guide: Business Intelligence »Reports »Reports in Use
3.0 version
You are currently viewing documentation for version 3.0 which is not a long-term support release. The latest long-term support release is version 1.6

Reports in Use

This section contains several examples of the report configuration:

Aggregate Data in the Report

Below is an example of a simple report that displays a particular budget per opportunity.

../../../_images/reports_examples_1.png
  1. Once you set up the Budget amount column, click Add to add it into the Columns list.

  2. Click Save.

  3. You are now redirected to the report view that shows the opportunities with the known Budget Amount:

    ../../../_images/reports_examples_2.png
  4. Click Edit to continue the report configuration.

Let us see what happens after we use the Count function for the Opportunity Budget column:

  1. Click to update the column and change the function for the Budget amount to Count.

    ../../../_images/reports_examples_3.png
  2. Click Save. The report data changes:

    Report Preview (Function = Count)

    ../../../_images/reports_examples_4.png

Similarly, you can use sum, max, average, and min functions.

Report Preview (Function = Sum)

../../../_images/reports_examples_5.png

The sum of Budget Amount values of all opportunities makes $202,565.00.

Report Preview (Function = Max)

../../../_images/reports_examples_6.png

The biggest budget amount value of the opportunity is $9,902.00.

Use Simple Grouping by Value

You can group the information in the report by unique values in the column(s).

../../../_images/reports_examples_7.png

The report preview:

../../../_images/reports_examples_8.png

Use Grouping by Value at Multiple Levels

You can group records based on several columns (e.g. per opportunity status and the B2B customer name).

../../../_images/reports_examples_9.png

Now, you can see the calculated budget metrics (total, average, min, and max) for all the opportunities with the same status that belong to a specific customer.

The report preview:

../../../_images/reports_examples_10.png

Hint

Once a report is generated, you can click the name of a column to sort all the data in the report by the specified field value (ascending or descending).

Here is an example of the report ordered by the Name column:

../../../_images/reports_examples_11.png

As you can see in the outlined area, there are opportunities which are both in progress and lost for Albers Super Markets. You can view the budget details for the both groups.

Note

If the customer’s name is the most important part of the grouping, it might be reasonable to edit the report and move the column to make it first.

Use Charts

Let us make a chart for the budget per opportunity status report (not grouped by customers).

Configuration:

../../../_images/reports_examples_12.png

Output:

../../../_images/reports_examples_13.png

Related Topics

Use System Reports

Use Custom Reports

Browse maintained versions:
3.01.6

You will be redirected to [title]. Would you like to continue?

Yes No
sso for www.magecore.comsso for oroinc.desso for oroinc.frsso for marketplace.orocommerce.comsso for marketplace.orocrm.com