Bucketing a date into days, then sorted by Sunday,Monday,etc....

q = load "x_pokeOppty";
q = foreach q generate q.'mv_prod.ProductCode' as 'mv_prod.ProductCode', q.'Gross_Margin_Dollars__c' as 'Gross_Margin_Dollars__c','Acct.CreatedDate' as 'Acct.CreatedDate',day_in_week(toDate('Acct.CreatedDate_sec_epoch'))  as 'DayCreated','Acct.CreatedDate_Year' as 'CreatedDtYear';
q = foreach q generate  'mv_prod.ProductCode',  'Gross_Margin_Dollars__c','Acct.CreatedDate', 'DayCreated','CreatedDtYear',case when ('DayCreated'==1) then "Sunday"when ('DayCreated'==2) then "Monday" when ('DayCreated'==3) then "Tuesday" when ('DayCreated'==4) then "Wednesday" when ('DayCreated'==5) then "Thursday" when ('DayCreated'==6) then "Friday" when ('DayCreated'==7) then "Saturday" end as 'dayString';
q= group q by ('dayString','DayCreated','CreatedDtYear');
q=foreach q generate  'DayCreated' as 'DayCreated','dayString'  as 'daystring', 'CreatedDtYear', count() as 'dayCount';
q=order q by 'DayCreated' ;