Make data date wise

gauravgg — Tue, 04 Apr 2017 10:35:05 GMT

I have the following table

Budget:

load * inline

[

Plant,Month ,Value,Year

P1,Jan,100,2016

P1,Feb,100,2016

P1,Mar,100,2016

P1,Apr,100,2016

P1,May,100,2016

P1,Jun,100,2016

P1,Jul,100,2016

P1,Aug,100,2016

P1,Sep,100,2016

P1,Oct,100,2016

P1,Nov,100,2016

P1,Dec,100,2016

];

the above budget table by month

I want to make it day wise data i.e i have sum up the Value and divide by 365 (sum(Value)/365) and group by Plant

Re: Make data date wise

vinieme12 — Tue, 04 Apr 2017 10:39:21 GMT

LOAD Plant,

Year

Sum(Value)/365 as DailyAverage

From XXXx

Group by Plant,Year;