The presentation of statistics or summary tables is often required in a management application. This type of presentation can be used for example to follow:

the evolution of orders in time,
the evolution of turnover,
the evolution of stocks,
...

Any executive manager wants to get this information.

WINDEV proposes several controls allowing you to easily include this information in your applications. Two specific controls will be used in this lesson:

the Chart control.
the Pivot Table control.


	Answer	If you did not create the windows in the previous lessons, you can follow this lesson by opening a corrected project: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (with windows)". A full corrected application project is also available: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (Answer)".

Displaying data in a Chart control

To handle the Chart control in real conditions, we are going to create a Chart control displaying the status of sales in the "WD Full Application" application.

First of all, we are going to create a query used to select the data that will be displayed in the Chart control.

Selecting the data that will be displayed in the Chart control

To create our chart, we want to get the sum of orders by date.

We are now going to create a query used to perform a sum. Indeed, we are going to calculate the total amount of orders (TotalIOT item in the Orders data file).

We are going to calculate the total amount of all orders per date (the Turnover per date).

Create a new query:
1. Click among the quick access buttons.
2. The element creation window appears: click "Query".
3. We are going to create a select query. Select the "Select" option. Go to the next step.
4. The query description window appears.
5. Add the items Orders.Date and Orders.TotalIOT to the query:
  - On the left, expand the "Orders" data file.
  - Double-click the Date item then the TotalIOT item.
  - The two items appear in the middle of the screen (in the "List of elements in your query" area).

To calculate the sum of values of "Orders.TotalIOT":
1. Select the "Orders.TotalIOT" item in the middle.
2. In the "Actions", on the right, select "Sum". The sum description window appears.
3. Validate the sum description. The sum of "TotalIOT" was added into the list of query result.


	Remark	You will notice that the query editor of WINDEV creates the queries in everyday's language (and also in SQL language). This allows you to check the purpose of your query.

We are now going to group the data by year and to sort it:
1. Select the "Orders.Date" item in the middle.
2. In the "Actions", on the right, click "Year, month" and select "Year". A window appears allowing you to create the Year item:
3. Validate this window ("OK").
4. The "Year" item is displayed in the middle of the query description.
5. Select the "Year" item and define the sort:
  - Open the popup menu of the "Year" item.
  - Select "Sort item .. Sort in ascending order".
  - An arrow appears in the query description, indicating the sort type.

The query is created. We are going to give it a name and to save it.
1. At the top of the query description window, enter:
  - the name "QRY_SalesEvolutions".
  - the caption "Sum of orders by date".
2. Validate the query description window.
3. The save window is displayed. Validate the proposed information.
4. The graphic query representation is as follows: