1 Reply Latest reply on Dec 26, 2018 9:09 AM by luisa.bez

    Jump Plot as Timeline

    luisa.bez

      I've read Chris Demartini's blog post about jump plots and have downloaded his workbooks, but I'm stuck building mine. I'm trying to create a timeline showcasing on which days I travelled during each year (one hop = one trip). Both width and height should represent the number of days travelled. The line should be flat when I wasn't travelling. I've decided to create a node for each day as the nodes are equidistant in Chris's example. It's supposed to look like this:

       

      IMG_20181226_152020.jpg

       

      I've noticed that my calculations for

       

           Node Num Int = WINDOW_MIN(MIN([Node]),FIRST(),FIRST())

       

      and

       

           Node Num Sec = WINDOW_MIN(MIN([Node]),LAST(),LAST())

       

      return the same value so my y values are zero and I can't create the Bezier curve.

       

      They look like this in Chris's baseball jump plot:

       

       

      Whereas I get the following result:

       

       

      I've attached Chris's pitcher workbook and my travel workbook.

       

      Any help would be appreciated!