select ((select count(Call) from "log" where "Call" = 'answered') / (select count(Event) from "log"))
I'm trying to run this query in canvas, but i only get this error message:
[essql] > Unexpected error from Elasticsearch: [unsupported_operation_exception] null
When I run the same query in SQL it works fine. Does canvas support multiple SELECT in the same query?