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

Tutorials in the same category

Tutorial: Overlapping Chart

In this sample, we’ll see how to create a chart using the resource of Overlapping. 1 – Cr...

Tutorial: Chart with scroll

In this sample we’ll see how to create a chart using the scroll resource. 1 – Create a ch...

Tutorial: Zoom line Chart

In this sample we’ll see how to create one analytic chart in lines using a zoom resource in one de...

Chart / Trend Zone

To place a trend line within our charts, the following steps must be performed: 1 -...

Comment this post