1 Reply Latest reply: Mar 15, 2012 2:44 PM by Marc Livingston RSS

    Help to display 90 days record

    Dipesh Patel

      Hi,

       

      I am trying put a chart to display no name create in the last 90 days by title.

      here is my ruff data:

      Title Name Create Date
      A AB 15/03/2012
      A VA 02/02/2011
      A EA 01/02/2012
      A DF 07/03/2012
      B ER 15/03/2012
      B BF 02/02/2011
      B QW 01/02/2012
      B WE 07/03/2012
      C ET 15/03/2012
      C TY 02/02/2011
      C YU 01/02/2012
      D IU 15/10/2011
      E AZ 29/11/2011
      I AX 27/02/2012
      I AC 19/08/2011
      J AF 15/02/2012
      K GH 02/02/2012

       

      the result may come below

       

      Title  Count

      D        1

      E        1

      I          1

       

      Can some one please advise what expression should work to display no name in last 90 days by title?

       

      Thanks,

      Dinesh