I'm using ESSQL in Kibana Canvas to plot a line chart. I have a field date and want to group my data by "YEAR-MONTH".
My query is something like this:
SELECT date, duration FROM my_index GROUP BY date
but I need something like this:
SELECT DATE_FORMAT(date, 'YYYY-MM') as date, duration FROM my_index GROUP BY date
Is there any workaround to achieve this?