Tutorial: Analytical Line Chart

In this example, we will see how to create a graph of analytical lines using the Grid application.

Creating a new Grid

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 “Grouping” tab in the application menu, then click on “Static group by >> New Grouping“.

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

4. Return to the initial options “Grid Modules“

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 “Line” table and in the “Generate chart” option, change it to “analytical“. 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} + {price order};

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

13. Mark only the “Sum” 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