Make data date wise

[gauravgg]

Hi

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

[vinieme12]

LOAD Plant,

     Year

     Sum(Value)/365 as DailyAverage

From XXXx

Group by Plant,Year;