0 Replies Latest reply: Jun 20, 2017 4:11 AM by Benoît Gochel RSS

    Comparing two date ranges

    Benoît Gochel

      Hi evrebody,

       

      I would like to implement a table which compare two ranges of dates previously selected with a date range picker.

       

      I already have a tab with those informations :

       

      Screenshot_1.png

       

      The Sales P-1 and Sales P are defined with a simple combo box filter (YTD, 0-12/12-24, etc.) with the held of a variable.

       

      num(Sum({<$($(vLVarP1)),$(vSetSales)>}[$(vFieldCurrency)]),'$(vNumFormatKPI)')

      Is my variable used for Sales P.

      The vSetSales is my set analysis with the sum of my sales, then the currency etc.

      For the period, the vLVarP1 is important. It's this one that is linked to another set of variables, dynamically changed with the combo box selection. For instance, if the 0-12/12-24 is selected the value

       

      Fiscal_Year,PeriodID_Now={">$(=$(vMaxMOPeriodIDNow)-24)<=$(=$(vMaxMOPeriodIDNow)-12)"},FiscalQuarter,Date,Year,Month,Period,Fiscal_Month,FiscalNMonth,FiscalPeriod,Date_Now,Date_Now_Name,Date_Name,Fiscal_Year_Text,Cal_Period_Now

       

      is set to the variable.

       

      Now, I would to change this logic, and be able to chose with two date range pickers the two periods that I compare.

      Do you think It's possible and can someone please explain me how to do it?

       

      Thank you in advance.