kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From deva namaste <ohd...@gmail.com>
Subject Get daily average for periodic readings
Date Wed, 28 Feb 2018 21:51:17 GMT
Hello,

How would I calculate value for a week while I have bi-monthly values.

e.g. Here is my data looks like -

Date       -  Value
01/18/2017 -  100
03/27/2017 -  130  (68 Days)
05/17/2017 -  102  (51 Days)

I need average value per week, as below. Lets consider between 03/27 and
05/17. So total days between period are 51. so Daily average would be
102/51= 2.04

Week4 (Starting March 26, #days = 4) = (4 x 2.04) = 8.16
Week1 (Starting Apr 2, #days = 7) = 14.28
Week2 (starting Apr 9, #days = 7)= 14.28
Week3 (starting Apr 16, #days = 7)= 14.28
Week4 (starting Apr 23, #days = 7)= 14.28
week5 (Starting Apr 30, #days =7)= 14.28
week1 (starting May 7, #days = 7)= 14.28
Week2 (starting May 14, #days = 4)= 8.16

But as you see that period from 01/18 to 03/27, have 68 days and daily
average would be 130/68=1.91

So really to get complete week I need 3 days from 130 value and 4 days from
102 value.

So real total for that first week would be -
Week4 (Starting March 26, #days = 4) = (4x2.04=8.16) + (3x1.91=5.73) = 13.89

How would I achieve this in Kylin? Any function? or other method I can use?
Just for 6 records for year, I dont want to populate daily records.
Thanks
Deva

Mime
View raw message