Analytics SAQL Developer Guide
jNewer Version Available
Day in the Week, Month, Quarter, or Year
Returns the day in the specified time period for a given date. These functions
answer questions like "do we close more deals at the beginning or end of a
quarter?".
Example
Suppose that you want to see on which day of the week most deals are closed. Use day_in_week(date).
1q = load "Data";
2
3q = foreach q generate day_in_week(toDate('Close_Date_sec_epoch')) as 'Day In Week Closed';
4
5q = group q by 'Day In Week Closed';
6q = foreach q generate 'Day In Week Closed' as 'Day In Week Closed', count() as 'count';
7q = order q by 'count' desc;The resulting data displays the number of opportunities closed, grouped by the day of the week that the opportunities were closed on.
It looks like most opportunities are closed on Thursday (day 5).
day_in_week(date)
Returns an
integer representing the day of the week for a specific date. For example, 1 = Sunday, 2
= Monday.
1q = foreach q generate day_in_week(toDate('Close_Date_sec_epoch')) as 'Day In Week Closed';day_in_month(date)
Returns an
integer representing the day of the month for a specific
date.
1q = foreach q generate day_in_month(toDate('Close_Date_sec_epoch')) as 'Day in Month Closed';day_in_quarter(date)
Returns an
integer representing the day of the quarter for a specific
date.
1q = foreach q generate day_in_quarter(toDate('Close_Date_sec_epoch')) as 'Day in Quarter Closed';day_in_year(date)
Returns an
integer representing the day of the year for a specific
date.
1q = foreach q generate day_in_year(toDate('Close_Date_sec_epoch')) as 'Day in Year Closed';