6 Replies Latest reply: Jun 17, 2016 5:24 AM by lingling Guo RSS

    Select option

    lingling Guo

      Hi, I would like to have a bar char counting the number of project is in the "PEP", ' Tender', 'Start', 'End' phase in the next X month. and i have a option (Radio or checkbox or list) to chose whether is 3 month or 6 month or 1 year. I have no idea how to do it,  Please advance me, thanks:)

       

      Project TitlePhaseStart DateEnd Date
      AEnd1/8/20171/8/2017
      APEP1/1/201631/3/2016
      AStart1/8/201631/7/2017
      ATender1/4/201631/7/2016
      BEnd1/7/20181/7/2018
      BPEP1/1/201631/3/2016
      BStart1/8/201630/6/2018
      BTender1/4/201631/7/2016
      CEnd1/1/20161/1/2016
      CStart10/3/201531/12/2015
      CTender10/11/20149/3/2015
      DEnd1/6/20161/6/2016
      DStart1/1/201631/5/2016
      DTender1/9/201531/12/2015
      EEnd1/12/20191/12/2019
      EPEP1/6/201731/8/2017
      EStart1/1/201830/11/2019
      ETender1/9/201731/12/2017
      FEnd1/7/20161/7/2016
      FPEP13/3/201412/6/2014
      FStart13/10/201430/6/2016
      FTender13/6/201412/10/2014
      GEnd1/12/20161/12/2016
      GPEP1/6/201531/8/2015
      GStart1/12/201530/11/2016
      GTender1/9/201530/11/2015
      HEnd1/12/20161/12/2016
      HPEP1/1/201631/3/2016
      HStart1/8/201630/11/2016
      HTender1/4/201631/7/2016