1 Reply Latest reply: Mar 4, 2014 2:44 PM by Manish Kachhia RSS

    Create Timeline for activities based on start- and enddate

    dick elsman

      Hello all,

       

      I am dealing with an issue at the moment.

      currently I am building a dashboard that should function as a timeline. with this I mean: I have a few activities that are linked to a startdate. the startdate from the second activity however, is the enddate of the first activity.

       

      the following example should explain it:

      given is the following table:

      activitydate
      talking1-1-2013
      drinking20-1-2013
      eating22-2-2013
      running12-5-2014
      sleeping2-6-2014

      now the activity 'Talking' starts at 1-1-2013 and ends at 20-1-2013, because then the activity 'Drinking' starts. The activity 'Drinking' ends on 22-2-2013 because then the activity 'eating' starts and so on.

       

      so when I should click the date 15-1-2013, the activity 'talking' should be activated, and so on

       

      I currently have this, but I cant figure out what to do.

      Can you guys help me?

       

      Thanks in advance,

       

      Dick