Built-in Functions → weeknum

weeknum() is a conversion function that returns the week number of the current week for the current year, where a week starts on Sunday and ends on Saturday.

Signature

weeknum()

Returns

int representing the week number for the current date.

Example

Identify the week number for the current date, 08/26/2021.

weeknum()

The following table illustrates the behavior of the weeknum() conversion function:

Product Revenues weeknum()
CD $200 35
Hard disk $600 35
Cable $550 35
Hardware $800 35
Memory Card $220 35

The current date, August 26th, is in the 35th week of the year. Thus, the count of the weeknum() is 35.


Use the following steps for detailed instructions on how to use the weeknum() conversion function to tackle the above example in an insight:

Note

In the Cluster Management Console (CMC), create a tenant that includes Sample Data. The Sample Data includes the SALES schema.

  • In the Navigation bar, select the Content tab, and then select + New → Add Dashboard.
  • In the Add Dashboard dialog, for Name, enter Product Dashboard, and then select Add.
  • In the Action bar, select + (add icon), or select + Add Insight.
  • In the Insight panel, select Listing Table or V.
  • In Tables, select Aggregated Table.
  • In the Data panel, select Manage Dataset.
  • In the Manage Data Sets panel, in Tables, select SALES. Close the panel.
  • From the Data panel, drag and drop the following columns to the respective tray:

    • Category from the PRODUCTS table to the Grouping Dimension tray.
    • Revenue from the SALES table to the Measure tray.

      • In the Properties panel, for Number Format, select Dollar Rounded.
  • From the Data panel, drag and drop Add Formula to the Grouping Dimension tray.
    The Formula Builder automatically opens:

    • In Search Functions, select the down arrow, and then select Conversion Functions.
    • Double-click the weeknum function, weeknum(), to add the formula to the editor.
    • Select Validate & Save.
  • In the Properties panel, for Column Label, enter weeknum().
  • Name the insight Revenue Per Category.
  • In the Action bar, select Save.