[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: #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

[ghudgins]

Closing this issue because this is supported in Lens visualizations. If you are trying to access the "other" bucket totals you can use the overall_sum function in lens formula which includes the terms split + the other bucket. This has also been added to data table visualization as well. Let us know if this doesn't solve this case!

Since this would require a large development effort to implement in TSVB and our efforts are focused on extending the functionality of Lens in easy-to-use and consistent way. We aim to provide the best possible visualization editing experience in Lens and are working to improve that tool and help users migrate.