Tutorial: Analytical Radar Chart

In this example we will see how to create an analytical radar graph using the Grid application.

Creating the Grid application

1. We will create a new Grid application based on the order table.

2. To enable the graph in a Grid, we must first create a group in the application. Then go to the “Group by” tab in the application menu, then click on “Static group by >> New group by“.

3. Select the fields: “employeeid” and “orderdate” (per month).

4. Return to the initial “Grid Modules” options

5. Mark the “Graph” as the initial module and enable it.

6. Access the “Summary” guide in the application menu, then click on “Graphics >> Settings“.

7. Select the “Radar” table and change the other settings according to the image.

8. Go to the “Fields >> New field” option in the application menu.

9. Create a field of type “currency” called “total“.

10. Go to the “Events >> onRecord” option in the application menu.

11. Use the following code in the event.

{total} = {freight} + {priceorder};

12. Go to the “Totalization” tab in the application menu, then click on “Fields“.

13. Verify only the “total” column in the “total” field so that the sum of the values ​​in this field is created.

14. Now go to the “Summary” tab in the application menu, then click on “Charts >> Column Charts“.

15. Check to show only the “total_sum” field “empoyeeid“, depending on the image.

16. Click on the “Run application” button.