Changes in this version:
- A number of new pivot table function have been added:
geometric and harmonic means,
variances and standard deviations,
counting specific numbers,
counting strings based on regular expressions,
kurtosis,
skewness,
most frequently occurring numbers and strings.
Sample screenshots:
https://citadel5.com/upd_screens/gsb16/gsb16_scr1.png
https://citadel5.com/upd_screens/gsb16/gsb16_scr2.png
To maximize performance, the pivot functions can make use of up to 100 processor cores.
- A few “copy” functions have been added to the pivot table context menu to make it easier/faster to copy them to other programs.
Sample screenshot:
https://citadel5.com/upd_screens/gsb16/gsb16_scr3.png
- The len() function has been modified to return the actual total size of a given binary field,
if it’s applied to binary fields. - A few issues with percentile functions in pivot tables have been fixed.(For example, only one such function could be use at a time.)