Day-values
Hello!
I have a scenario that I would like some help solving.
1) Data about how many orders a webshop has recieved is sent to an item. This is stored as delta, and is never reset. It simply stores how many orders there is in the database. I would like to know how many orders were added since the last date-change, for example if it is 11:00 am, i would like the delta for the last 11 hours. If possible, I would also like to know how many orders were placed yesterday (so 24 hours back, starting from midnight). I would like to do this as a calculated item.
2) Another item stores the number of logged in users currently. I would like an item showing the max value for today, meaning max since midnight. Also would like to know yesterday's max if possible..
Any help with this? Much appreciated!
I have a scenario that I would like some help solving.
1) Data about how many orders a webshop has recieved is sent to an item. This is stored as delta, and is never reset. It simply stores how many orders there is in the database. I would like to know how many orders were added since the last date-change, for example if it is 11:00 am, i would like the delta for the last 11 hours. If possible, I would also like to know how many orders were placed yesterday (so 24 hours back, starting from midnight). I would like to do this as a calculated item.
2) Another item stores the number of logged in users currently. I would like an item showing the max value for today, meaning max since midnight. Also would like to know yesterday's max if possible..
Any help with this? Much appreciated!
Comment