Hi,
I am looking to put the current date in to canvas for our reports, any ideas how i could do this?
Thanks
Hi,
I am looking to put the current date in to canvas for our reports, any ideas how i could do this?
Thanks
Hi,
You can add Time filter
element, from the list of elements.
Hi @majagrubic,
I am already filtering the report, i need to display the current date on the report.
Depending on the format of your data, you can use a Markdown widget and an ES query to fetch the latest timestamp from your documents. That would require that you have documents with today's date in your ES data.
You can then do something like this:
Elasticsearch SQL
as data sourcefilters
| essql
query="SELECT timestamp as CurrentDate FROM \"kibana_sample_data_flights\"
ORDER BY timestamp DESC
LIMIT 1"
| markdown "Current date is {{#each rows}}{{CurrentDate}}{{/each}}"
| render
Thats perfect, got that working
© 2020. All Rights Reserved - Elasticsearch
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.