🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Removing aggregation options

Sumukh asked on September 10, 2019

I want to remove a few aggregations which appear in the fields window. such as “Sample StDev”,”Population StDev”. I know how to remove from the context menu using customizeContextMenu() . But need help to remove aggregation submenu from fields and from every other place where the aggregation is available.
So can you please tell is there any workaround.

filter window.png

6 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster September 10, 2019

Hello Sumukh,
Thank you for your question.
The Sample StDev and Population StDev aggregations can be removed from the list using availableAggregations approach: https://www.flexmonster.com/api/slice-object/. You can define the list of aggregations which is supported for each measure: https://jsfiddle.net/flexmonster/tp80euuq/.
In case you need totaly disable aggregation drop-down, please use showAggregations options property: https://www.flexmonster.com/api/options-object/.
Let us know if everything works fine for you.

vaibhav September 18, 2019

I am using the same method to limit the aggregation options (through availableAggregation). Using which I am able to limit the aggregation of “number” type successfully. But for “string” and “date string” this method is not working. Please provide help.

Vera Didenko Vera Didenko Flexmonster September 18, 2019

Thank you for writing to us.
We have managed to reproduce the issue you describe.
Our team will provide the fix in the minor release version with the ETA 7th of October.
You are welcome to contact us in case of questions.
Best Regards,

Sumukh October 7, 2019

Hi Vera,
Can we expect a minor release version today?

Vera Didenko Vera Didenko Flexmonster October 8, 2019

Hello, Sumukh,
We are pleased to inform you that the issue with availableAggregations parameter for non-numeric fields was fixed.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please contact us in case any questions arise.
Best Regards,

Sumukh October 8, 2019

Thank you will update and check

Please login or Register to Submit Answer