I am charting some data using the ChartJs plugin.
Currently I receive numerous data point per day through my application. I am currently not sure how to only show the last data point or most recent data point for that day (Below is an example chart and the data points below it). As you can see for the 25th it is showing the data in red, but I would like the data in green to be shown instead. I have been playing around with this query but for whatever reason I am only able to show the first data point per day. Can someone please tell me how to go about writing this query correctly.
Y AXIS – This seems to work fine. It shows each of the unique days.
X AXIS – Not sure how to make a call for the last data point for that day.