Filter output based on condition in a table

  • What are you trying to achieve?

I have a table generated from ES datasource. Several filters were applied from Transform tab. Now I want to apply condition on one of my column such as "if (doc['type'].value == 'cpu') {return (_value / 3600)} else {return 0 }.

Can I do it using any option inside transform? I tried to include directly in query but then it doesnot display the rest

Welcome

What kind of visualization are you using? This type of data checking can be done in plugins that have js capabilities such as apache echart for grafana

I am using Grafana Dashboard with ES as datasource for the table panel.