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?