Getting Time

Version

Application Scenario

The Get Time function can be used to directly obtain different time granularity values of an original data field.

For example, if the original field is 2017-01-03 12:00:00, its year 2017 and month 01 can be obtained through this function.

Function Description

The Get Time function supports 17 units: year, quarter, month, month-day, week, day, week quantity, hour, minute, second, year-quarter, year-month, number of weeks in a year, year-month-day, year-month-day-hour, year-month-day-hour-minute, and year-month-day-hour-minute-second.

Assume that you want to obtain the months when contracts are signed for later analysis of whether the number of contracts signed is related to the month.

The following uses Contract Fact Table as an example.

Sample data: Contract Fact Table.xlsx

The field Contract Signing Time already exists in this table. How can you obtain the months when customers signed contracts?

(1) Download the sample data Contract Fact Table, create an analysis subject, upload the dataset, and enter the data editing page.

(2) Choose More > Get Time directly. Alternatively, click the + icon and choose More > Get Time, as shown in the following figure.

(3) In the dialog box that is displayed, name the new time column, set Select Field to Contract Signing Time, and set Get Time to Month, as shown in the following figure.

4) Click OK. The months of the contract signing time are successfully obtained.