12.25
2
6.60
0.00
1
2.50
0.67
3
9.00
0.00
1
3.30
7.47
6
15.00
4.47
6
18.00
5.04
5
16.50
0.00
1
2.50
0.00
1
3.00
3.25
4
10.00
0.69
4
12.00
0.00
1
3.30
0.00
1
2.50
11.39
7
21.00
2.25
2
6.60
1.19
4
10.00
2.19
4
12.00
2.50
4
13.20
9.56
3
9.00
0.00
1
2.50
9.00
2
6.00
1.00
2
6.60
9.00
2
5.00
0.00
1
3.00
0.25
2
6.60
0.00
1
2.50
3.25
4
12.00
12.25
2
6.60
1.00
2
5.00
0.00
1
3.00
0.22
3
9.90
4.00
2
5.00
8.56
5
15.00
Regina
Andrew
Sven
Elio
Guylene
Michael
Antoni
Nancy
Peter
Ian
Shelley
Yoshi
Caffe Espresso
sum
count
variance
Caffe Americano
sum
count
variance
Doubleshot Espresso
sum
count
variance

Description

This is an example of Pivot Grid with custom a custom data aggregation function. The pivot grid provides several built-in functions: count, sum, min, max, average, product. In this example, we implement a custom function that calculates the variance of the data points of the respective pivot grid cell. To add or modify existing data aggregation functions, set the customAggregationFunctions property of the pivot data source. Each pivot aggregation functions must have a unique name, take an array of values as a parameter and return a number. For performance reasons, make sure that the function runs as quickly as possible. The pivot grid will call the function multiple times during the data pivoting operations.