2 Replies Latest reply: Mar 31, 2016 4:03 AM by ashok Velisetty RSS

    List Box for last 7, 14, 30 days?

      Here is what I have written for the listbox expression:

       

      =Aggr(

      if(Date(Day)>Date(mDate-7), '7',

      if(Date(Day)>Date(mDate-14),'14'))

      ,Day)

       

      mdate is the maximum date, saved as a variable during the load script.

       

      The resulting listbox has '7' and '14' as options.

      '7' works as intended.

       

      However, selecting '14' only selects 7 days, between 14 and 7 days old.

      How do I fix this so '14' selects all 14 days?