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