3 Replies Latest reply: Oct 4, 2017 5:57 AM by Phil Speight RSS

    Set Analysis a week ago Dynamic

    Phil Speight

      Hi

       

      The following expression shows data based on any data for when the roster date=today.

       

       

      (Count({<

      Sickness_SMART.Roster_RosterDate={'$(=Today())'}

      >} [Sickness_SMART.Full Name]))

       

       

      I want to create the same expression for this day last week, but it returns zero.  See below

       

      (Count({<

      Sickness_SMART.Roster_RosterDate={'$(=Today()-1)'}

      >} [Sickness_SMART.Full Name]))

       

       

      Any thoughts why it doesn't work