Canvas Chart Area using count/sum and Timestamp

Elastic Stack Kibana
4

I found a solution !
I used DATE_TRUNC which in fact does exactly what the combination DATE_PARSE and DATE_FORMAT does :

SELECT DATE_TRUNC('days', startDate::datetime) as date,
count(*) as c FROM "vendors" 
WHERE nonTaxedPrice=0  group by date

With this all my timestamps are formated : Date trunc Documentation

1 Like