Dear visitor, despite all the challenges, our team continues operating at full speed.

We are ready to help with any questions you may have. Please fill out this quick form and we'll get back to you.

Fill the form
Get Free Trial

How to set or disable the aggregated selected cells’ tooltip

Answered
Marc Wentinck asked on July 24, 2020

In a fmpivot table when you select cells by dragging over the cells you will see a rectangular border with at the down right side a sort of tooltip with average, count and sum. Can you influence the text that is written there? Can you disable the tooltip altogether?
I have tried this, but that did not help.
this.fmpivot.flexmonster.setOptions({ showAggregations: false });
 
 
 

Attachments:
AggregatedTooltip.gif

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster July 24, 2020

Hello,
 
Thank you for reaching out to us.
Our team would like to kindly explain that the auto calculation bar mentioned in your question can be disabled using the showAutoCalculationBar property of the grid object.
 
Also, please note that the refresh API call should be called after the setOptions method execution in order to apply changes.
 
Please see the following code snippet for the reference:

flexmonster.setOptions({
grid: {
showAutoCalculationBar: false
}
});
flexmonster.refresh();

 
Finally, our team wants to draw your attention to the fact that in case the auto calculation bar needs to be hidden by default, the corresponding property should be included in the report object as following:

report: {
dataSource: {
...
},
options: {
grid: {
showAutoCalculationBar: false
}
},
...
}

 
We hope it works for you.
Do not hesitate to contact us in case other questions occur.
 
Regards,
Illia

Public
Marc Wentinck July 24, 2020

Thanks Illia! I tried it and it works.
Just one thing, I never expected this tooltip to be called ‘AutoCalculationBar’, and in the documentation there is not much explanation about what it actually is either. It just says: grid.showAutoCalculationBar, Boolean. Indicates whether the autoCalculationBar feature is turned on (true) or not (false). Default value: true
So I was looking with the wrong search terms and could not find the option. But it works.
There is no way to actually influence the text written in the AutoCalculationBar? (Apart from the language and translations used.)
 
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster July 24, 2020

Hello,
 
Thank you for your feedback.
 
Our team will consider improving the documentation dedicated to the mentioned property.
 
Concerning customization of the auto calculation bar, we want to inform you that it is not possible in the current version of Flexmonster. It allows displaying only the predefined set of aggregations (average, count, sum).
 
Do not hesitate to contact us in case any other questions occur.
 
Best regards,
Illia

Please login or Register to Submit Answer