I'm using ElasticseachSQL queries to populate elements in Canvas.
I'd like to find a way of creating a Line chart to display a DAILY cumulative count of row entries for a given month.
To get the entries i do the following:
SELECT COUNT(*) AS entries, DAY_OF_MONTH(entry_date) AS day FROM data_table WHERE MONTH_OF_YEAR(entry_date) = MONTH_OF_YEAR(NOW()) AND YEAR(entry_date) = YEAR(NOW()) GROUP BY day ORDER BY day
not in Canvas, but in the regular Visualizations of Kibana you can do this with the cumulative sum pipeline aggregation
Yes, exactly, i have been able to produce the exact chart i need in Visualisations, however i'd like it part of a Canvas alongside other metrics (for display purposes)
you could create a regular Dashboard iso a Canvas workpad with this table.
Could you clarify - can i create a visualisation and copy it across to Canvas?
no, you cannot add visualizations from the Kibana Visualize app to a Canvas workpad now.
I meant that perhaps a dashboard with that visualization would work for your purposes as well. Although I do understand that Canvas has more styling options for look&feel.
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.