Hi. Spanish is my mother tongue so please excuse my Poor draft and lexicon. .

Well here is my problem:
I want get a flow medition from a physical medition on level.

For example:

Columns are: Location, HH:MM and Level.


1 08:55 10
1 09:00 12
1 09:05 14
1 09:10 17
1 09:15 19
1 09:20 31
1 09:50 51


All points (Locations) generate a acumulative value (Level).

I want that when i get (In server location) those Levels value i can get a Flow Medition (from present and past values of Levels).

Something like this:
Columns are: Location, HH:MM, Count, Day Minute, Count/hour

Loc Hour count day_min flow
1 08:55 10 535,00
1 09:00 12 540,00 0,40
1 09:05 14 545,00 0,40
1 09:10 17 550,00 0,60
1 09:15 19 555,00 0,40
1 09:20 31 560,00 2,40
1 09:50 51 590,00 0,67

In this case values came from relation into t0 and t-1.

But i want some more smooth values. Is important note like you see in example that sampling interval is 5min but we can loose some samples.


Other need is try to get a projection of count value for a specific hour example 8:00pm

Any help will be well received.

Thanks.