Hi @Mandy88, Canvas does support Elasticsearch raw documents for non-aggregated data, although depending on the amount of data, you may have performance issues. You can also set your refresh interval to 5 seconds in Canvas for it to poll your data constantly. If you could share where you are getting stuck I can try and be more helpful!
Hi @tims, Thank you for your reply. I'm stuck in a tricky point of a graph, Delay Time. The difference between the last event @timestamp(a time when last event indexed) and Current Time.
For last event @timestamp in Canvas I'm using this query - |essql query="SELECT last("@timestamp") as lastevent FROM "cisco-asa-*"".
Now the next hurdle is fetching a Curent Time and for that I didn't find any function in Canvas.
Is there any method in Canvas to use this script functionnew Date().getTime() - doc['@timestamp'].value
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.