@David_Wong TMST is my time field and Daily production is the calculated field.
Daily_MaxGCNT = periodToDatemaxOverTime(max(GCNT), TMST, DAY)
Daily_Production = periodOverPeriodDifference({Daily_MaxGCNT},TMST, DAY, 1)
where GCNT is my counter value
I tried this way but it gives me in accurate values as first record is missing.
testCount = periodToDateCountOverTime(count(extract(‘DD’,TMST)), TMST, MONTH)
last_Count = lastValue(testCount,[TMST ASC])
running = sumOver(Daily_Production )
Daily_Avg = running / {last_Count}
These are my calculations to find the average value but it gives inaccurate because of the missed first daily production record.
Maybe there is some other best way to find the average of the daily production, but when I tried with level aware calculations I always got errors, that is why I tried this way.
Any help would be greatly appreciated. Thanks in advance