Updating Variables from analysis
I'm looking to create a graph widget in where it needs to display the LAST VALUE of each day based on a variable that is saved every 1 minute in my bucket. Something like this graph:
I though about using my analysis to store a secondary variable, so for every new record that arrives from my device, I can UPDATE a so called daily_value or create a new one in case it doesn't exist. This would allow me to use the regular Line chart.
My questions would be:
1) Is this the best way to accomplish a daily value chart from a multiple to single value?
2) How to UPDATE a value in a bucket?