Self-paced online course
Recommended Skills/Experience prior to taking course:
• Ability to create unconditional and conditional computed fields
Datetime fields may be presented in a variety of formats, including ones that include entire time stamps (such as YYYY-MM-DD hh:mm:ss). While this allows for much more granular and powerful analysis, sometimes, you may only want to work with a certain component of the field, such as the month. For example, calculating how many transactions occurred in a given month.
Episode 1 Part I Objectives:
• Create unconditional computed fields to:
• Parse various year, month, and day components from a datetime field
• Convert each of these numeric computed fields to character fields
• Calculate the day of week (ex. Saturday) and the month name (ex. June)
Functions used: STRING(), CMOY(), CDOW(), DAY(), MONTH(), and YEAR() functions.
Episode 1 Part II Objectives:
• Create conditional computed fields to:
• Calculate the fiscal year
• Calculate the fiscal quarter
Functions used: BETWEEN(), YEAR(), and STRING() functions.
Episode 2 Objectives:
• Determine the number of and subtotaled amount of transactions in each fiscal year and month (Classify command)
• Determine the number of and subtotaled amount of transactions in each fiscal year, quarter, and month (Summarize command)
• Generate a detailed summary of transactions by month and day, and transactions by User ID and day of week (Cross-Tabulate)
Estimated Time: 3-5 hours
CPE: None - 0
You selected to get the course Basics of Datetime Fields Le... (ACL 210). Please Login to get it.