|
|
|
|
|
|
|
|
- When should the aggregation be used?
- Aggregation and type of charts
grColumnAggregation (Function) In french: grHistoAgrégation Defines the algorithm for aggregating data in a clustered or stacked Column chart. // Code of Radio Button control used to select the aggregation type
// Store the selected type of aggregation
let nAggregation = SWITCH (RADIO_AggregationType, grhaNone, grhaMax, grhaMin, grhaMean, grhaSum)
// Apply the aggregation
grColumnAggregation(CHART_Chart, nAggregation)
// Redraw the example
grDraw(CHART_Chart)
Syntax
grColumnAggregation(<Chart name> , <Algorithm>)
<Chart name>: Control name or character string Name of the chart to be used. This name corresponds to:- the chart name defined through programming with grCreate.
- the name of the Chart control (in the window, page or report editor).
<Algorithm>: Integer constant Aggregation algorithm to use: | | | grhaMax | Aggregation according to the maximum of data. | | grhaMean | Aggregation according to the mean of data. | | grhaMin | Aggregation according to the minimum of data. | | grhaNone | No aggregation. | | grhaSum | Aggregation according to the sum of data. |
Remarks When should the aggregation be used? When displaying a Column chart, the bars may become too small to be displayed. This is the case for the charts presenting a time scale. In this case, it becomes necessary to display a bar whose minimum size is the size of a mark and aggregating the data of all potential bars found in this mark. Example: | |
Non-aggregated Column chart |
Column chart aggregated according to the mean |
Aggregation and type of charts - For the charts without time scale, the aggregation is not enabled by default.
- For the charts with time scale, the default aggregation is the sum of columns.
Related Examples:
|
Training (WINDEV): WD Chart
[ + ] This example presents the different uses of the Chart control. Different types of charts are presented: - Pie - Sunburst - Line - Scatter - Column - Area - etc. The main features presented here are the possibility to customize of charts from the code, as well as to fill the chart from an HFSQL data file, or in the editor.
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|