3 Replies Latest reply on Nov 14, 2016 10:46 AM by Min-Yu Tsai

    Unified multiple date columns to create bar or line graphics

    Min-Yu Tsai

      Hello,

       

      I have a dataset contains multiple binary flag fields and date columns related to each flag for each unique ID.  It is very similar to attached file. (due to sensitivity of the information I can not provide the data file I am working on)

       

      I am trying to create a neutral date axis and plot aggregation of each flag into bar or line char.  Basically to show on certain date, # ID has Received flag= 1 and # of ID has Processed flag =1 etc. Like the graphic below.  I also want to explore the possibility of plotting running total of each flag, along the date to demonstrate progression along the time.  How do I make it happen without pivoting all flags and date columns?  Pooja Gandhi

       

       

      Any suggestion is greatly appreciated.  Thanks so much!

       

      MT