PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

This page concerns the 23 + version of WINDEV, WEBDEV, WINDEV Mobile. Upgrade your version.
  • When should the aggregation be used?
  • Aggregation and type of charts
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
grColumnAggregation (Function)
In French: grHistoAgrégation
Defines the algorithm for aggregating data in a grouped or stacked Column chart.
Example
// Code of Radio Button control used to select the aggregation type
// Stores the selected type of aggregation
let nAggregation = SWITCH (RADIO_AggregationType, grhaNone, grhaMax, grhaMin, grhaMean, grhaSum)

// Applies the aggregation
grColumnAggregation(CHART_Chart, nAggregation)

// Redraws the example
grDraw(CHART_Chart)
Syntax
grColumnAggregation(<Chart Name> , <Algorithm>)
<Chart Name>: Character string (with or without quotes)
Name of chart to use. This name corresponds to:
  • the chart name defined by programming with grCreate.
  • the name of Chart control (found in the window editor, page editor or report editor).
<Algorithm>: Integer constant
Aggregation algorithm to use:
grhaNoneNo aggregation.
grhaMaxAggregation according to the maximum of data.
grhaMinAggregation according to the minimum of data.
grhaMeanAggregation according to the mean of data.
grhaSumAggregation 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
Non-aggregated Column chart
Column chart aggregated according to the mean
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 bars.
Related Examples:
WD Chart Training (WINDEV): WD Chart
[ + ] This educational example present different uses of the chart control.
The following charts are presented:
- Semi-circular
- Donut
- Pie
- Sunburst
- Line
- Scatter
- 3D Scatter
- Column
- Area
- Bubble
- Radar
- Funnel
- Surface
- Waterfall
- Composite

The main features presented in this example are the ability to customize the charts by programming as well as the method used to fill a chart from a HFSQL file or in the editor.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230grf.dll
Linux wd230grf.so
Minimum required version
  • Version 23
This page is also available for…
Comments
Click [Add] to post a comment