4 Replies Latest reply on Aug 24, 2018 8:46 AM by matt hins

    Set Date Range by Day Start / End

    matt hins

      Hi, I'm trying to setup a dashboard that requires exact date range for CNTD calculations.

       

      For example:

      Group A = CNTD(Persons) in date range 17Sep 2014 - 07Sep 2015

      Group B = CNTD(Persons) in date range 08Sep 2015 - 09Sep 2016

      Group C = CNTD(Persons) in date range 10Sep 2016 - 13Sep 2017

      Group D = CNTD(Persons) in date range 14Sep 2017 - 16Sep 2018

       

      Is there a good way to write up a calculation that would allow me to define year start & end dates?

       

      Thank you,

      Matt