5 Replies Latest reply on Sep 17, 2018 9:24 AM by Jonathan Brough

    Include a data point between a Start and End Date

    stephen.desmond

      Hi all,

       

      I have a little problem I'm trying to solve and would greatly appreciate some help.

       

      I have a dataset that lists Projects with a START DATE and an END DATE.

       

      What I'm hoping to do is in a trended view of weeks, have any date that is NOT the End Date have a value to indicate it's being worked on and a different value when it reaches the end date week. Effectively, I'm hoping to use these values to then show shapes to indicate whether something is still be worked on or is completed.

       

      Any assistance with this would be greatly appreciated.

       

      Thanks,

      Stephen