Description
Use a date field to create a variable that separates the date values into Months. For instance, a table showing enrollment status over the year (see below).
How To
Use the code below to create the calculated variable.
Variable Finder tab: Add a date variable by which the data will be grouped (columns)
On Expression tab:
Exclude Previous Years Approach:
function main() {
if (isNull(V1))
return 14;
} else {
var myMonth = V1.getMonth() + 1; // JavaScript has Jan=0, Feb=1, etc., thus add 1 so that Jan=1, Feb=2, etc.
var myYear = V1.getFullYear();
if (myYear <= 2016) { // previous year = 2016, replace as appropriate
return 13;
} else {
return myMonth;
}
}
}
On the Pick List tab:
Create (e.g., 1 = January, 2 = February, etc. through 13="Previous Year"; 14 = "Missing Date")
Alternate method that ignores the year:
In this example, don't need a pick list option for 12/Previous Year
function main() {
if (isNull(V1)) { // check to make sure the date field exists
return 13;
} else {
var myMonth = V1.getMonth();
return myMonth;
}
}