# Showing multiple metrics with conditions and calculation in visualize tool in Kibana
**URL:** https://discuss.elastic.co/t/showing-multiple-metrics-with-conditions-and-calculation-in-visualize-tool-in-kibana/203624
**Category:** Kibana
**Created:** [October 15, 2019, 10:52am UTC](https://discuss.elastic.co/t/showing-multiple-metrics-with-conditions-and-calculation-in-visualize-tool-in-kibana/203624 "2019-10-15T10:52:45Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@axlb](https://discuss.elastic.co/u/axlb)
#### Post date: [October 15, 2019, 10:52am UTC](https://discuss.elastic.co/t/showing-multiple-metrics-with-conditions-and-calculation-in-visualize-tool-in-kibana/203624/1 "2019-10-15T10:52:45Z")
I want to create a table in the Visualize tool in Kibana where I show several metrics with condition and calculcation. I have created a generic example in excel, see below. I know the basics. On how to produce the first two columns, be the other ones are harder. I tried looking into adding JSON input with adding another Count and adding a script, but i dont get it to work unfortunately. Any ideas?
---
### Author:  [@azasypkin](https://discuss.elastic.co/u/azasypkin)
#### Post date: [October 15, 2019, 1:05pm UTC](https://discuss.elastic.co/t/showing-multiple-metrics-with-conditions-and-calculation-in-visualize-tool-in-kibana/203624/2 "2019-10-15T13:05:03Z")
Hi @axlb,
I don't think this is supported currently, but can be tracked [here](https://github.com/elastic/kibana/issues/3620). Also there is a chance that a 3rd-party [kibana-enhanced-table plugin](https://github.com/fbaligand/kibana-enhanced-table) can do what you want.
Also it _may be possible_ to achieve this with [Canvas](https://www.elastic.co/blog/kibana-canvas-data-table-and-debug-elements) and ES-SQL too, you'd need to experiment.
Best,
Oleg
---
### Author:  [@axlb](https://discuss.elastic.co/u/axlb)
#### Post date: [October 15, 2019, 2:32pm UTC](https://discuss.elastic.co/t/showing-multiple-metrics-with-conditions-and-calculation-in-visualize-tool-in-kibana/203624/3 "2019-10-15T14:32:44Z")
Hi. I tried Canvas with ES-SQL before but it has limitations in the queries (ORDER BY gives timeouts for example).
I did actually solve it in Visualize by myself by using the table in Visual Builder, utilizing Filter Ratio for the fourth column and a basic Filter for third column (using multiple Metrics just to be clear). Then, I just added the visualization in a dashboard.It's not perfect, but it suit my needs as of now.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 12, 2019, 2:33pm UTC](https://discuss.elastic.co/t/showing-multiple-metrics-with-conditions-and-calculation-in-visualize-tool-in-kibana/203624/4 "2019-11-12T14:33:01Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.