11 Replies Latest reply on Jul 22, 2018 8:39 AM by Abhilash Sharma

    Rolling 12 month date bins

    Kate Abercrombie

      Hello -

       

      I am trying to build dynamic rolling 12 month date bins to place data. In my data set, I have a launch date dimension that is in standard date form. I want to create 4 rolling 12 month bins:

      1) All launch dates that fall within 12 months from today

      2) All launch dates that fall between 12 months and 24 months from today

      3) All launch dates that fall between 24 and 36 months from today

      4) All launch dates that fall between 36 and 48 months from today

       

      I am struggling with a calculated field to do this. Any pointers?

       

      Thanks,

      Kate