Custom Time Range for Summing144
Pages:
1
|
PigFarmer private msg quote post Address this user | |
| Wow, Mike we met at CTO a couple weeks ago. Fantastic tool - mad props for your efforts here. I think I have determined how to do a lot of the basic stuff at this point. I am getting bogged down on some more advanced stuff (or at least advanced for me). How do you sum data points from a custom period of time? Example: Say I have a propane tank on my hog barn. It is filled with 1,000 gallons on 11/12/14 at 13:00. I have a propane sensor that computes gallons consumed and reports into GS. I want to sum that data from 11/12/14 13:00 on to know how many gallons I have left in my propane tank. Can you set it up for the expression to just automatically find that fill timestamp in the tank stream and then sum the data from then on or does that have to be done in a custom application through an API? Does anyone have any thoughts on how to do this? Thanks! Brad |
||
| Post 1 • IP flag post | ||
|
MikeMills private msg quote post Address this user | |
| Hi Brad, thanks for the feedback. Great use case. Sometimes the easy ones are the toughest to model. We'll see with this one. How does the sensor compute gallons consumed? Is it reporting gallons/hour every hour (or some other period) or does it report an amount at random times? |
||
| Post 2 • IP flag post | ||
|
|
PigFarmer private msg quote post Address this user | |
| Its going to be uploaded to GS at random times. This will be a similar case as feed bins. | ||
| Post 3 • IP flag post | ||
|
|
MikeMills private msg quote post Address this user | |
| The randomness of both streams makes it a bit of a challenge, but we think we have a solution. But it requires a small enhancement. We'll try it out and post the solution when we know it works - probably a week or two. | ||
| Post 4 • IP flag post | ||