Convert SQL query to Timelion query

I am pretty new to timelion and I cannot figure out how can I convert my SQL query to timelion query.

Here is my SQL query:
SELECT "@timestamp", env, ROUND((100 -(sla.timeout + 0.0) / (sla.searches) * 100.0),2) as service_availability from "service*" where sla.searches is not null and env='seapr1' order by "@timestamp" desc

Any idea how can I achieve that?
Thank you.

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