Mysql to elasticsearch Query conversion

[Croos (Croos Nilukshan)]

@Croos

Help me to convert this MySQL query to elasticsearch (json) query and how to set it on kibana.

SELECT user, call_date, sum(call_length_in_sec) as 'work_time', (max(end_epoch)-min(start_epoch))-sum(length_in_sec) as 'idle_time' FROM vicidial_log WHERE date(call_date)='2016-01-12' group by user

ok. Thanks for your response. I have posted the same as a new discussion. please refer it on the following link.

Convert MySQL query to elasticsearch

Help me to convert this MySQL query to elasticsearch (json) query and how to visualize it on kibana. SELECT user, call_date, sum(length_in_sec) as 'work_time', (max(end_epoch)-min(start_epoch))-sum(length_in_sec) as 'idle_time' FROM vicidial_log WHERE date(call_date)='2016-01-12' group by user