In this example, a Dashboard application will be created showing a grid and a chart.
Creating a Grid
This application will display a summary of the quantity and value of the products, by categories.
1 – We will create a new Grid type application, based on the “products” table.

2 – To enable the summary in a Grid, we must first create a “Group by”. Access the “ Group by ” tab in the application menu and click on “Static Group by >> New Group by”.

3 – Select the following fields according to the image.

4 – Return to the initial options of “Grid Modules”

5 – Enable only the “summary” module and place it as an initial application.

6 – Generate the source of the application.

Creating the Chart
This application will display a chart with the value of the products by categories.

1 – We will create a new application of the chart type, also based on the “products” table.

2 – Once the application has been created, we must select the fields that we will use as a grouping of dimensions and metrics.

3 – Then click on the “chart” tab and select the type of chart you want to view.

4 – Generate the source of the application

Creating the Dashboard
1 –We proceed to create an application of the Dashboard type
2 – In the Dashboard configuration, click on “Add Link Widget”.

3 – In the first widget, add the Summary application by clicking on the pencil icon, then type the name of the application and click save.

4 – In the second widget, add the Chart application by clicking on the pencil icon, then type the name of the application and click save.

5 – Save the changes and run the application
Comment this post