18 Replies Latest reply: Mar 28, 2014 11:31 AM by Vinay Naran RSS

    Set Analysis Expression

    Goutham Kandukuri

      Hi Experts,

       

       

      I am trying to get count of using below expression

      count({<[Date Closed] > $(VInputDate)> , <Status={'Closed'}>, <Severity= {'High'}>} Status)

       

      The above expression was working fine without the date comparison "[Date Closed] > $(VInputDate)"

       

      Date Closed is the database filed which has random dates and VinputDate is a variable which changes dynamically. I know this is simple but am struggle to get the total count of the status which Vinputdate is < Date closed.

       

      It would be great if some one could help

       

      Thanks

      Goutham

       

      Message was edited by: Goutham Kandukuri