I am migrating the log reports from direct search with oracle SQL to Kibana,
and I am creating the dashboard to show the existing log reports.
May I know is it possible to get the result like the following query and how can I do.
select profile, status, count (*) from tableA where trx_id in (select distinct trx_id from tableB where ... ) group by profile, status;
p.s. My Kibana version is 6.2.3