LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Excel function replication in LAE graph

    Employee
    Posted 02-05-2016 07:43

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ritban

    Hello,
    I have a problem of replicating an excel function in Lavastorm. I have three columns Created_Date,Date(always current date) and Holiday(static file) and I am calculating the Age using NETWORKDAYS function in Excel. Is there any way to replicate this Age Calculation through a graph. Any pointers would be appreciated.

    Created date
    12/7/2015
    12/7/2015
    12/21/2015
    1/5/2016
    3/27/2013
    11/12/2013

    Date
    2/5/2016
    2/5/2016
    2/5/2016
    2/5/2016
    2/5/2016
    2/5/2016

    AGE
    43
    43
    33
    24
    720
    562

    Holiday

    1/1/2009
    4/10/2009
    4/13/2009
    5/18/2009
    7/1/2009
    8/3/2009
    9/7/2009
    10/12/2009
    11/11/2009
    12/25/2009
    12/28/2009
    1/1/2010
    4/2/2010
    5/24/2010
    7/1/2010
    8/2/2010
    9/6/2010
    10/11/2010
    11/11/2010
    12/27/2010
    12/28/2010
    1/3/2011
    4/22/2011
    4/25/2011
    5/23/2011
    7/1/2011
    8/1/2011
    9/5/2011
    10/10/2011
    11/11/2011
    12/26/2011
    12/27/2011
    1/2/2012
    4/6/2012
    5/21/2012
    7/1/2012
    8/6/2012
    9/3/2012
    10/8/2012
    12/26/2012
    12/27/2012
    1/1/2013
    3/29/2013
    5/20/2013
    7/1/2013
    8/5/2013
    9/2/2013
    10/14/2013
    12/25/2013
    12/26/2013
    1/1/2014
    4/18/2014
    5/19/2014
    7/1/2014
    8/4/2014
    9/1/2014
    10/13/2014
    11/11/2014
    12/25/2014
    12/26/2014
    1/1/2015
    4/3/2015
    5/18/2015
    7/1/2015
    8/3/2015
    9/7/2015
    10/12/2015
    11/11/2015
    12/25/2015
    12/26/2015
    1/1/2016
    3/25/2016
    5/23/2016
    7/1/2016
    8/1/2016
    9/5/2016
    10/10/2016
    12/25/2016
    12/26/2016

    Regards
    Ritban


  • 2.  RE: Excel function replication in LAE graph

    Employee
    Posted 02-22-2016 12:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi Ritban,

    You can use the Calculate Workdays node that can be found in the Profiling and Patterns category of the node library. The Calculate Workdays node actually provides functionality equivalent to the Excel WORKDAT.INTL function so it also supports weekend days that are not Saturday - Sunday.

    The attached data flow shows how the node can be configured to deliver the results you require.

    Excel_NetworkDays_Example.brg

    Best regards,
    Adrian


  • 3.  RE: Excel function replication in LAE graph

    Employee
    Posted 02-22-2016 12:26

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    BTW the Filter node used to rename the output field can be removed if you specify the field name for the calculation results in the 'OutputFieldName' parameter )on the Optional tab).

    Also, if your input data has the 'Created Date' field but not the 'Date' field (which you say is always the current date) you can use a filter node to add today's date using the following script:

    emit *, date() as "Date"

    Best regards,
    Adrian