Data table standardization

Elastic Stack Kibana
1

Hello

I am trying to build a "proportional bar" chart in order to substitute the usual pie chart. I am using an horizontal stacked bar with Counts by group, but I will need to standardise data table values. Should I use the SQL query? Or how can I use the TinyMath operators to divide all the column values by the total?

Thank you

2

Could the Canvas functions on datatable be helpful here?

3

Hi, there a blog post on how to do these calculations in TSVB: How to display data as a percentage in Kibana visualizations | Elastic Blog

For using Canvas, there is another Discuss topic that asks something similar: How to perform divide math operation in elasticsearch SQL

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.