We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

BUG: AllowDataCompression=TRUE makes a mess in aggregation

Hi,

with the uploaded sample, you can reproduce a bug in pivot table when AllowDataCompression=true.

Switch from Sum to Avg on column ExecNom -> the avg is not calculated


With Sum:

With Avg => Avg is not calculated, the number remains the calculation of Sum; and another column PerfVsVWAP reset to 0 !




When you set  AllowDataCompression=false, every thing is ok.




Are you aware there is bug on data compression ?


Thanks

Yi


3 Replies

YH Yi Han December 13, 2022 10:03 PM UTC



RG Rajeshkannah G Syncfusion Team December 14, 2022 10:17 AM UTC

Hi Yi Han,


Please find the response below


Query

Comments

“Switch from Sum to Avg on column ExecNom -> the average is not calculated

We would like to inform you that the pivot table does not support the "Average" aggregation type when the data compression option is enabled. Please see our UG document below for more information on data compression limitations.

 

Document : https://blazor.syncfusion.com/documentation/pivot-table/virtual-scrolling#data-compression

 

 

“another column PerfVsVWAP reset to 0 “

 

We have considered this as a bug “Pivot Table values not displayed properly while changing aggregation type during AllowDataCompression enabled”. And this fix will be available in our December last weekly release, which is estimated to be rolled out at Dec 28, 2022.  The following feedback link will help you keep track of it.

 

Feedback Link:  https://www.syncfusion.com/feedback/39769/pivot-table-values-not-displayed-properly-while-changing-aggregation-type-during

 


With Regards,

Rajeshkannah Gopalakrishnan



AP AngelinFaithSheeba PaulvannanRajadurai Syncfusion Team December 28, 2022 04:05 PM UTC

Hi Yi Han,


We are glad to announce that our weekly Release V20.4.40 is rolled out and fix for the issue “Pivot Table values not displayed properly while changing aggregation type during AllowDataCompression enabledhas been included in this release. Please refer to the following sample.


Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/PivotTableAllowDataCompressionBug_eb8486cd-1727272250


Output screenshot:


We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.


Regards,

Angelin Faith Sheeba.


Loader.
Up arrow icon