How to create a new Aggregate Grid report

Version: Yurbi v12

Role: Builder or higher

Permission: Builder access to the application


Overview

Aggregate Grid Report offers more power and includes more total and subtotal features incorporated when configuring it than using the options menu in the report fields.

In this guide, we will talk about how to configure the report, the different uses of its aggregate function and how each configuration affects the report output.

Also, as of now, drill-down capabilities does not exist within the aggregate grid type of report.

Accessing the Builder Section

This section shows the step on how you can access the builder section

1. Once logged in, click Builder option found at the left side bar.

A screenshot of a service deskAI-generated content may be incorrect.

 

Creating Aggregate Grid Report

This section shows the steps on how you can create your aggregate grid report

Select Application and Report Type

1. Click the down arrow next to Select an App and Report Type to open the dropdown menu.

A screenshot of a computerAI-generated content may be incorrect.

Or, Click the Select an App and Report Type button found in the middle of the interface

A screenshot of a computerAI-generated content may be incorrect.

2. Choose the application you wish to build a report for. The options are the applications you are authorized to modify.

A screenshot of a phoneAI-generated content may be incorrect.

3. Now, pick the type of report you intend to create. Depending on the application, different report types will be available for your selection.

A screenshot of a computerAI-generated content may be incorrect.

Building Your Report

This section shows the steps on how you can build from the report you created

1. With a report type selected, a report tree will appear. This contains all possible fields for your report.

A screenshot of a phoneAI-generated content may be incorrect.

2. Click the plus icon (+) next to the fields you want to add. These will become the columns in your report and will be reflected in the preview area.

A screenshot of a phoneAI-generated content may be incorrect.

For more in depth process, here is an article on how to create a new data grid report from scratch.

3. Once you have your selected fields, they will appear in the report fields section.

A screenshot of a computerAI-generated content may be incorrect.

4. Under Preview Section, click Visualization

A white rectangle with black textAI-generated content may be incorrect.

Select Aggregate Grid

A screenshot of a computerAI-generated content may be incorrect.

5. You’ll be taken to the configuration of the report.

A screenshot of a computerAI-generated content may be incorrect.

6. At the left side is the preview of the report, where each changes the user makes will reflect real-time.

Configure Visualization

This section explains how the user can configure the selected report field within the aggregate grid report they are building.

1. Under Configure Visualization, you can see the selected report field for the report you are building.

2. When the checkboxes found on each report field are ticked off, this means that they are included in the report.

A screenshot of a computerAI-generated content may be incorrect.

A screenshot of a computerAI-generated content may be incorrect.

3. If user wants that specific field not to be included, simply click on the check box.

A screenshot of a computerAI-generated content may be incorrect.

A screenshot of a computerAI-generated content may be incorrect.

4. To configure each report field, click on the three dots button.

A screenshot of a computerAI-generated content may be incorrect.

Here are each actions mean:

A screenshot of a computerAI-generated content may be incorrect.

Grouped By: This is useful when you want to group the data by geography, date, or status / stage of a data such as won, lost, or in progress.

1. Click on Grouped By, select Grouped to activate it

A screenshot of a computerAI-generated content may be incorrect.

A screenshot of a ticket statusAI-generated content may be incorrect.

2. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

3. Click None to deactivate

A screenshot of a computerAI-generated content may be incorrect.

A screenshot of a computerAI-generated content may be incorrect.

4. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

Grand Totals has the following functions.

A screenshot of a surveyAI-generated content may be incorrect.

  • Count: Counts the instances of how many the data appear in the report. Example would be a sales pipeline where its report field is a deal stage with values in progress, won, and lost under it. This function will count how many in progress, won, and lost you have.
  • Sum: Adds all the value of the selected report field. Example would be the select field value is currency. This function will total all the currency you have.
  • Max: This function displays the maximum value of the selected field. Example would be the select field value is currency, it will display the highest currency under that field.
  • Min: This function displays the minimum value of the selected field. Example would be the select field value is currency, it will display the lowest currency under that field.
  • Avg: This function displays the average value of the selected field. Example would be the select field value is currency, it will display the average under that field.

1. Simply click on the desired function to activate it.

A screenshot of a phoneAI-generated content may be incorrect.

2. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

3. Click None to deactivate it.

A screenshot of a surveyAI-generated content may be incorrect.

4. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

Column Format: By default, Yurbi will display the format based on the value of the report field.

1. To change, simply select a format you want that field to have.

A screenshot of a cell phoneAI-generated content may be incorrect.

2. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

Note: If the value under name is a text, select string value in format. If its value is money, select currency.

Column Width: This enables the user to adjust the column width of the report field.

1. Simply input a number

A screenshot of a computerAI-generated content may be incorrect.

2. Click Save

A blue rectangle with white textAI-generated content may be incorrect.

Heading Colors : Applicable only when data are grouped by.

1. Click on Heading Colors Section

2. Select Ground Top Level Color

A screenshot of a computerAI-generated content may be incorrect.

A screenshot of a computerAI-generated content may be incorrect.

3. Select Group Sub Level Color

A screenshot of a computerAI-generated content may be incorrect.

A screenshot of a computerAI-generated content may be incorrect.

4. Click Save & Apply

A blue rectangle with white textAI-generated content may be incorrect.


And there you have it! You now know how to create an aggregate grid report from scratch!