{"id":4007,"date":"2018-01-14T07:09:04","date_gmt":"2018-01-14T12:09:04","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis5208sp18\/?page_id=4007"},"modified":"2018-12-14T12:19:58","modified_gmt":"2018-12-14T17:19:58","slug":"lab-07-basics-of-datetime-fields-learning-series-basic-intermediate-acl-210","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/lab-07-basics-of-datetime-fields-learning-series-basic-intermediate-acl-210\/","title":{"rendered":"Lab 07 – Basics of Datetime Fields Learning Series (Basic-Intermediate) (ACL 210)"},"content":{"rendered":"
<\/div>\n
\n
\n
\n
\n
\"Basics<\/p>\n

Register \/ Resume Course <\/a><\/div>\n

\n

Basics of Datetime Fields Learning Series (Basic-Intermediate) (ACL 210)<\/span><\/span>0%<\/span><\/span><\/span><\/h2>\n


<\/p>\n

\n
\nDESCRIPTION<\/legend>\n

Self-paced online course
\n3-5 hours
\nIntermediate<\/p>\n

Recommended Skills\/Experience prior to taking course:
\n\u2022 Intermediate
\n\u2022 Ability to create unconditional and conditional computed fields<\/p>\n

With the release of ACL Analytics 10.5, time components were added to datetime fields, meaning that entire time stamps (such as YYYY-MM-DD hh:mm:ss) can now be analyzed! While this allows for much more granular and powerful analysis, sometimes, we 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.<\/p>\n

Episode 1 Part I Objectives:
\n\u2022 Create unconditional computed fields to:
\n\u2022 Parse various year, month, and day components from a datetime field
\n\u2022 Convert each of these numeric computed fields to character fields
\n\u2022 Calculate the day of week (ex. Saturday) and the month name (ex. June)
\nFunctions used: STRING(), CMOY(), CDOW(), DAY(), MONTH(), and YEAR() functions.<\/p>\n

Episode 1 Part II Objectives:
\n\u2022 Create conditional computed fields to:
\n\u2022 Calculate the fiscal year
\n\u2022 Calculate the fiscal quarter
\nFunctions used: BETWEEN(), YEAR(), and STRING() functions.<\/p>\n

Episode 2 Objectives:
\n\u2022 Determine the number of and subtotaled amount of transactions in each fiscal year and month (Classify command)
\n\u2022 Determine the number of and subtotaled amount of transactions in each fiscal year, quarter, and month (Summarize command)
\n\u2022 Generate a detailed summary of transactions by month and day, and transactions by User ID and day of week (Cross-Tabulate)<\/p>\n

Episode 3 Objectives:
\n\u2022 Create a workspace containing computed field definitions
\n\u2022 Activate the workspace with a table (field(s) referenced in the workspace have the same name as those in the destination table)
\n\u2022 Revise the workspace and activate it with a table whose field(s) are named differently from those in the workspace<\/p>\n

ESTIMATED TIME<\/span>: 3-5 HOURS<\/span><\/span><\/p>\n<\/fieldset>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Register \/ Resume Course Basics of Datetime Fields Learning Series (Basic-Intermediate) (ACL 210)0% DESCRIPTION Self-paced online course 3-5 hours Intermediate Recommended Skills\/Experience prior to taking course: \u2022 Intermediate \u2022 Ability to create unconditional and conditional computed fields With the release of ACL Analytics 10.5, time components were added to datetime fields, meaning that entire time […]<\/p>\n","protected":false},"author":21825,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"class_list":{"0":"post-4007","1":"page","2":"type-page","3":"status-publish","5":"entry"},"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/pages\/4007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/users\/21825"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/comments?post=4007"}],"version-history":[{"count":1,"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/pages\/4007\/revisions"}],"predecessor-version":[{"id":4374,"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/pages\/4007\/revisions\/4374"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis5208sec001spring2020\/wp-json\/wp\/v2\/media?parent=4007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}