All the Questions in this page use the below sample Dataset. It is the Orders Data for a fictitious seller.

Order NumberOrder DateShipping DateProductPrice ($)Profit ($)
000101 Jan 2018 08:30:01 AM03 Jan 2018 11:21:05 AMABC800150
000202 Jan 2018 01:15:25 PM05 Jan 2018 05:30:15 PMXYZ600120
..................

YEARS

Synonyms-
SyntaxYEARS([date])
DescriptionReturns a list of available Years.
Argumentsdate: (Optional) The Date Field to use when identifying Years. Pass it if the Years should be identified from a Field different from the Timestamp Field.
Examples
  • When used as a Dimension, it groups the Data-Rows into Years.
    e.g. TOTAL SALES IN YEARS(SHIPPING DATE)
  • When used as a Metric, it returns a list of available Years.
    e.g. SHOW YEARS(SHIPPING DATE)

QUARTERS

Synonyms-
SyntaxQUARTERS([date])
DescriptionReturns a list of available Quarters.
Argumentsdate: (Optional) The Date Field to use when identifying Quarters. Pass it if the Quarters should be identified from a Field different from the Timestamp Field.
Examples
  • When used as a Dimension, it groups the Data-Rows into Quarters.
    e.g. TOTAL SALES IN QUARTERS(SHIPPING DATE)
  • When used as a Metric, it returns a list of available Quarters.
    e.g. SHOW QUARTERS(SHIPPING DATE)

MONTHS

Synonyms-
SyntaxMONTHS([date])
DescriptionReturns a list of available Months.
Argumentsdate: (Optional) The Date Field to use when identifying Months. Pass it if the Months should be identified from a Field different from the Timestamp Field.
Examples
  • When used as a Dimension, it groups the Data-Rows into Months.
    e.g. TOTAL SALES IN MONTHS(SHIPPING DATE)
  • When used as a Metric, it returns a list of available Months.
    e.g. SHOW MONTHS(SHIPPING DATE)

WEEKS

Synonyms-
SyntaxWEEKS([date])
DescriptionReturns a list of available Weeks.
Argumentsdate: (Optional) The Date Field to use when identifying Weeks. Pass it if the Weeks should be identified from a Field different from the Timestamp Field.
Examples
  • When used as a Dimension, it groups the Data-Rows into Weeks.
    e.g. TOTAL SALES IN WEEKS(SHIPPING DATE)
  • When used as a Metric, it returns a list of available Weeks.
    e.g. SHOW WEEKS(SHIPPING DATE)

DAYS

Synonyms-
SyntaxDAYS([date])
DescriptionReturns a list of available Days.
Argumentsdate: (Optional) The Date Field to use when identifying Days. Pass it if the Days should be identified from a Field different from the Timestamp Field.
Examples
  • When used as a Dimension, it groups the Data-Rows into Days.
    e.g. TOTAL SALES IN DAYS(SHIPPING DATE)
  • When used as a Metric, it returns a list of available Days.
    e.g. SHOW DAYS(SHIPPING DATE)

HOURS

Synonyms-
SyntaxHOURS([date])
DescriptionReturns a list of available Hours.
Argumentsdate: (Optional) The Date Field to use when identifying Hours. Pass it if the Hours should be identified from a Field different from the Timestamp Field.
Examples
  • When used as a Dimension, it groups the Data-Rows into Hours.
    e.g. TOTAL SALES IN HOURS(SHIPPING DATE)
  • When used as a Metric, it returns a list of available Hours.
    e.g. SHOW HOURS(SHIPPING DATE)