Data table standardization

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

Could the Canvas functions on datatable be helpful here?

Hi, there a blog post on how to do these calculations in TSVB: https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations

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

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