Using Canvas on Kibana version 6.6.0. I'm new to canvas and struggling to display a line chart with counts over time. Below is the query I'm using. The time doesn't update whenever I change the time filter. I have the time filter using click_time as its timestamp.
SELECT HISTOGRAM("click_time", INTERVAL 1 hour) as dd, count(click_id)
, count(distinct member_id)
, count(distinct project_code)
, SUM(revenue)/count(distinct click_id)*100 as epc
, SUM(revenue) as rev
FROM "mr_monitor*"
WHERE customer='Prodege'
group by dd
No matter if I select last 30 days, 60 days, or 24 hours the time frame in the line chart always shows last 2-3 days.
Any help is appreciated!