6 Replies Latest reply on Feb 27, 2019 8:49 AM by Ganapathy Palanimuthu

    Period to date with 13 periods

    Xeni Xenu

      Hello everyone,


      I'm struggling to show period to date and comparing current period, with previous year specific period


      I have a column already in my excel sheet with the corresponding period number, all incidents occurring in the following date bands are split by period e.g 1/4/2018 - 28/4/2018 = period 1, 29/4/2018 - 26/5/2018 = period 2 etc, this is the same for the previous years (2015/2016, 2016/2017, 2017/2018)


      Is there a way to create a calculated field for 13 periods which will allow me to view data by period to date and allow me to compare periods from previous years?


      Thank you in advance for all your help