[SOLVED] Create calendar week out of date (German definition of calendar week)

Sylvia

Hello,

I'd like to analyze the number of contracts by calendar week based on a data extract which shows all contracts including the date of contract creation. The output table should include the number of created contracts grouped by product group, calendar week and year.

I transformed the contract creation date to calendar week using the operator "Date to Numerical" (time unit = week, week relative to year). Unfortunately the calendar week is generated based on the definition used in the US meaning that Sunday is the first day of a week. Is it possible to change the default settings so that the calendar week is generated according to the German definition (Monday is the first day of a week, each week has seven days, for the calendar week end of December / beginning of January the Thursday indicates to which year the calendar week belongs).

Thanks
Sylvia

Nils_Woehler

Hi Sylvia,

unfortunately you cant select the locale for the Date to Numerical operator. But i think you can use Date to Nominal and Parse Numbers afterwards as a workaround.
Here is a example process:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.2.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="5.2.001" expanded="true" name="Process">
    <process expanded="true" height="611" width="748">
      <operator activated="true" class="generate_sales_data" compatibility="5.2.001" expanded="true" height="60" name="Generate Sales Data" width="90" x="112" y="210"/>
      <operator activated="true" breakpoints="after" class="date_to_nominal" compatibility="5.2.001" expanded="true" height="76" name="Date to Nominal" width="90" x="447" y="210">
        <parameter key="attribute_name" value="date"/>
        <parameter key="date_format" value="w"/>
        <parameter key="locale" value="German"/>
        <parameter key="keep_old_attribute" value="true"/>
      </operator>
      <operator activated="true" class="parse_numbers" compatibility="5.2.001" expanded="true" height="76" name="Parse Numbers" width="90" x="581" y="210">
        <parameter key="attribute_filter_type" value="single"/>
        <parameter key="attribute" value="date_nominal"/>
      </operator>
      <connect from_op="Generate Sales Data" from_port="output" to_op="Date to Nominal" to_port="example set input"/>
      <connect from_op="Date to Nominal" from_port="example set output" to_op="Parse Numbers" to_port="example set input"/>
      <connect from_op="Parse Numbers" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
    </process>
  </operator>
</process>

Best,
Nils