Kibana: [TSVB] Access to the other buckets in Math aggregation

[marius-dr]

Right now params._all.<name>.values seems to only access each split's previous values in the buckets. In order to create a percentage column in the Data Table using the Math aggregation you should be able to access the values of all buckets in order to do something like this:
divide(params._all.count.values,sum(params._all.count.values))

This would solve some open issues: https://github.com/elastic/kibana/issues/19489 and it's a feature requested for a log time that was available in the old Math library.

[harsh1802]

Hi,
I am waiting for this feature for a long time. any update on this? In which release this feature will be available?
Regards,
Harsh

[rjso]

Hi all,

I would like to understand if this is now a possibility or not as I can see there was interest in this.

Also @marius-dr would be nice to know if you found a workaround for this. I understand new functionalities were created for the DataTables component but not necessarily for the TSVB one.

What we are trying to achieve seems to be a very plausible scenario. Which is in a table inside a TSVB component, show the percentage of the total (and not of the specific group) and for that we would have to have access to the total across buckets