Is there any way to use 'nested queries' in Discover or Views?

Elastic Stack Kibana
1

I'm searching the way how can I use Kibana to show which clients where buying -2 months ago but not -1month ago. Something that would have running two SQL queries:

SELECT count(*) FROM clients WHERE date BETWEEN '2018-07-01' AND '2018-07-31'

SELECT count(*) FROM clients WHERE client_id NOT IN (SELECT client_id FROM clients WHERE date BETWEEN '2018-08-01' AND '2018-08-31') AND date BETWEEN '2018-07-01' AND '2018-07-31'

Best if I could have pie chart or similar... maybe Timelion... But even Discover pane would be good to have raw data.

Possible to do this in Kibana?
Regards

2

That is currently not possible. Could you please open a feature request? https://github.com/elastic/kibana/issues/new?template=Feature_request.md

3

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