1 Reply Latest reply on Aug 12, 2018 11:51 AM by Jonathan Drummey

    Stacked Bar Charts with 4 fields containing future dates

    LISA MOORE

      I have 4 different fields with dates ranging from now through 2020.  Each field value relates to a unique issue id.  Each field represents a stage the issue goes through during the life of the issue id.  Sample data below.

       

      I want to take the data and create stacked bar charts.  the months along the x-axis and stacked with:

      # of lob val date

      # of audit val date

      # of arm val date

       

      Filter by Division to display all data or specific divisions only.  Thank you in advance.

       

      Issue iD

      Div

      Lob val date

      Eco val date

      Aud val date

      Arm val date

      444432

      East

      5/3/18

      8/8/18

      9/10/18

      12/8/18

      334455

      west

      6/13/18

      8/18/18

      10/3/18

      12/8/18

      443357

      south

      8/18/18

      9/9/18

      10/11/18

      12/18/18

      444432

      East

      6/13/18

      8/18/18

      10/3/18

      12/8/18

      443357

      south

      6/13/18

      8/18/18

      10/3/18

      12/8/18