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.
Could you share the full expression that you are using for the line chart? If you select the line chart, there should be an "Expression Editor" link in the bottom right corner where you can see this expression.
Nothing immediately jumps out at me as to what could be causing this based on that expression.
Couple of things to check.
If you remove everything from the expression after the query, does the resulting table have the expected date-filtered data in it?
If you delete everything and start over, does the issue remain? Canvas was in a beta until 6.8, and I know there were some issues with some filtering in some of those earlier releases.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.