1 Reply Latest reply on Jul 9, 2018 2:03 PM by Wesley Magee

    Date/Calendar Help

    Emily Alden

      I cannot seem to figure out how to get the data to display the way I want it to. I know how to do it if I completely restructure the data, but was hoping to avoid doing this.

       

      I have data in the following format

      Program
      ProcessStart DateDuration (Weeks)
      Quantity per Week
      ADesign1/18/20184500
      ACreate Pattern2/2/20182

      350

      AProduce3/3/20187

      400

      BDesign1/29/20182600

      .....

       

      The visualization I am struggling with is a vertical bar chart for each process that has one bar per week with the planned amount.

       

      So for "Design" the week of 1/15/2018 would have a vertical bar of 500, the week of 1/22 would have a vertical bar of 500, and 1/29 would have a vertical bar of 1,100.

       

      I am having difficulty getting a bar to show up on the week that I "don't have data for". I tried introducing a calendar with all dates and they saying "IF [DAY]  > = [Start Date]   AND   [Day]   <=   [Start Date]  +  7  *  [Duration] THEN [Quantity] END"  without luck.

       

      Is there anyway to get the visualization I want without restructruing my raw data?