We have daily volume for today (TDYVolume) and daily volume for yesterday ((YTDVolume). I need to calculate monthly/quarterly/yearly volume from daily volume for yesterday (YTDVolume). However, this YTDVolume has multiple same value for each day. For example

5/1/2019 1:00:30 400 bbl

5/1/2019 2:00:40 400 bbl

5/1/2019 5:20:40 400 bbl

...

For my calculation, I only need one value per day to sum them up. How can I do that? Also number of values each day are irregular and time stamps are irregular too.

We do have flow rate (Instantaneous rate bbl/d). The problem is calculation/backfilling is getting expensive over a period of time. The worst part is if I use TagTot to sum flow rate, I get incorrect data due to bad data quality in one month or two months.

Thanks,

Hi Kristy,

Why not add some compression filtering with a CompMax of 1 day? That way you would have a single value per day and you could do a event weighted total assuming you are using 2018 SP2, or calculate an event weighted total in an older version using TagMean()*EventCount(). For this to work though, compression needs to be setup to avoid duplicate values on the same day.

Hope this helps,

Seb