1 Reply Latest reply on Feb 17, 2017 10:21 AM by Tom W

    How to show milestones with 'awkward' data set

    timothy rafferty

      Hello...

       

      Please consider the following very simple example attached

       

      For each row I have a date and a count of things. In among that time line there are a few milestones

       

      How can I plot the count of things over time and 'superimpose' the milestone dates as 'points' on the chart ?

       

      I know this would be easy if I had a a column for milestone type and milestone date value .. but I don't... I actually have a very large table as per the example and can't manipulate the data outside of Tableau

       

      (see https://community.tableau.com/docs/DOC-5521 for the 'easy' answer)

       

                                                                                                                                      

      count datecountmilestone1milestone2milestone3
      01/01/201718
      01/02/201718
      01/03/20171201/03/2017
      01/04/201718
      01/05/201717
      01/06/20171101/06/2017
      01/07/201712
      01/08/201712
      01/09/201716
      01/10/20171401/10/2017
      01/11/201720
      01/12/201718