Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Week-day calculation

  1. #11

    Default

    hello guy,

    you can use codes

    node:nationality
    bretype:core::Composite
    editor:Label=nationality
    editor:sortkey=5cde8f2b355d04c7
    editor:XY=970,190
    node:Dates_Data
    bretype:core::Static Data
    editor:Label=Dates Data
    editor:sortkey=5c9894df3bee7f23
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    Start Date:date
    2019-04-25
    2019-04-26
    2019-05-31
    2019-05-28
    2019-03-29
    2019-03-30
    2019-03-31
    2019-04-01
    2018-04-02
    2018-07-04
    2018-12-31
    2019-02-28
    2019-03-01
    2019-04-12
    EOX
    editor:XY=910,110
    end:Dates_Data

    node:Calculate_Workday_Adusted_Dates_2
    bretype:core::Filter
    editor:Label=Calculate Workday Adusted Dates
    editor:sortkey=5c9899900bc23110_2
    input:@40fd2c74167f1ca2/=XRef_2.457826825d7c2de0
    output:@40fd2c7420761db6/=
    prop:Script=<<EOX

    workDayOffset = 15
    sign = 1
    incrementedDays = 0
    newDate = 'Start Date'
    while incrementedDays < abs(workDayOffset) {
    newDate = dateAdjust(newDate, sign, "days")
    if weekday(newDate) > 0 and weekday(newDate) < 6 and
    not('NATIONALITY_DATE'.str().strFind(newDate.str() )>-1) then {
    incrementedDays = incrementedDays + 1
    }
    }


    emit *, newDate as "Adjusted_Date"
    exclude 'NATIONALITY_DATE'

    EOX
    editor:XY=1230,170
    end:Calculate_Workday_Adusted_Dates_2

    node:Agg_Ex
    bretype:core::Agg Ex
    editor:sortkey=5cdcff5e5ed6587f
    input:@4b4668c040aa5a85/=NATIONALITY_DATE.40fe6c55598828e5
    output:@4b4668e708143fb4/=
    prop:GroupBy=<<EOX
    1
    EOX
    prop:Script=<<EOX
    NATIONALITY_DATE = groupString('NATIONALITY_DATE',",")
    emit NATIONALITY_DATE
    where lastInGroup

    EOX
    prop:SortInput=true
    editor:XY=910,250
    node:Bypass
    bretype:::Bypass
    editor:shadow=4b467f7e02db3a85
    input:@4b467f7e129d45c1/=
    input:@4b467f830ffe047b/=
    output:@40fd2c7436717256/=
    end:Bypass

    node:Sort
    bretype:::Sort
    editor:shadow=4b467f8972dc33df
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort

    node:Agg
    bretype:::Agg
    editor:shadow=4b467f9b3d5028c0
    input:@40fd2c7427456e5b/=
    output:@40fd2c744c862db0/=
    end:Agg

    end:Agg_Ex

    node:XRef_2
    bretype:core::X-Ref
    editor:sortkey=5cdcffed0f5c3c74
    input:@45781ca80c2802d0/=Dates_Data.40fe6c55598828e5
    input:@45781ca971fe502f/=Agg_Ex.4b4668e708143fb4
    output:@45781cad02e051b0/=
    output:@457826825d7c2de0/=
    output:@4578268450ad5d88/=
    prop:LeftInputKey=<<EOX
    1
    EOX
    prop:RightInputKey=<<EOX
    1
    EOX
    prop:SortLeftInput=true
    prop:SortRightInput=true
    editor:XY=1020,170
    node:Sort_2
    bretype:::Sort
    editor:shadow=45782670131b71e8
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort_2

    node:Bypass_3
    bretype:::Bypass
    editor:shadow=4578267017753cec
    input:@45782010749f0c96/=
    input:@457820124fef7658/=
    output:@40fd2c7436717256/=
    end:Bypass_3

    node:Join
    bretype:::Join
    editor:shadow=457826701862249e
    input:@40fd2c745b6d7704/=
    input:@40fd2c74504921cd/=
    output:@40fd2c7430f76546/=
    output:@457826cc03a465f4/=
    output:@457826cc510c69e0/=
    end:Join

    node:Bypass
    bretype:::Bypass
    editor:shadow=4578267041681261
    input:@45782010749f0c96/=
    input:@457820124fef7658/=
    output:@40fd2c7436717256/=
    end:Bypass

    node:Sort
    bretype:::Sort
    editor:shadow=4578267075a60d09
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort

    end:XRef_2

    node:NATIONALITY_DATE
    bretype:core::Static Data
    editor:Label=NATIONALITY_DATE
    editor:sortkey=5cde8e9d43040fff
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    NATIONALITY_DATE:date
    2021-01-01
    2021-04-23
    2021-05-12
    2021-05-13
    2021-05-14
    2021-05-19
    2021-07-15
    2021-07-19
    2021-07-20
    2021-07-21
    2021-07-22
    2021-07-23
    2021-08-30
    2021-10-28
    2021-10-29
    2017-05-01
    2017-05-19
    2017-06-26
    2017-06-27
    2017-08-30
    2017-08-31
    2017-09-01
    2017-09-04
    2018-01-01
    2018-04-23
    2018-05-01
    2018-06-14
    2018-06-15
    2018-08-20
    2018-08-21
    2018-08-22
    2018-08-23
    2018-08-24
    2018-08-30
    2018-10-29
    2019-01-01
    2019-04-23
    2019-05-01
    2019-06-04
    2019-06-05
    2019-06-06
    2019-06-07
    2019-07-15
    2019-08-12
    2019-08-13
    2019-08-14
    2019-08-30
    2019-10-28
    2019-10-29
    2020-01-01
    2020-04-23
    2020-05-01
    2020-05-19
    2020-05-25
    2020-05-26
    2020-07-15
    2020-07-30
    2020-07-31
    2020-08-03
    2020-10-28
    2020-10-29
    EOX
    editor:XY=780,250
    end:NATIONALITY_DATE

    end:nationality

  2. #12
    Lavastorm Employee
    Join Date
    Nov 2012
    Location
    Warrington, UK
    Posts
    245

    Default

    Following the migration of the Lavastorm support system to the Infogix support system all questions on LAE and questions about migrating to Data3Sixty® Analyze should be posted on the new community forum.

    You can access the Infogix support portal, which covers all Infogix products, here:

    https://support.infogix.com/hc/en-us

    To post a question follow the Community link from there to view the LAE community topics. Alternatively, you can go directly to the LAE Community topics using the following link:
    https://support.infogix.com/hc/en-us...0001073653-LAE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •