12 Replies Latest reply on Jul 20, 2018 7:36 PM by Ajay Kulkarni

    how to carry a difference from one pane to other

    Ajay Kulkarni

      Hello ,

       

      This is my data set

             

      orderdatetimeperiodcount
      7/11/18Before100
      7/11/18After40
      7/12/18Before30
      7/12/18After50
      7/13/18Before100
      7/13/18After102
      7/14/18Before100

      If you look at the data for 7/11, the BEFORE is 100 and AFTER is 70, meaning a difference of 30.

      I want to build a report that shows three bars for every date

      Bar 1 = BeforeCount

      Bar 2 = AfterCount

      Bar 3 = Backlog until previous date

       

      Ex - for 07/11

      Bar 1 = 100

      Bar 2 = 40

      Bar 3  = 0

       

      Ex - for 07/12

      Bar 1 = 30

      Bar 2 = 50

      Bar 3  = 60 (Subtract Bar1 from Bar 2 for the previous period ie 100 -40) and add Bar 3 of previous period ie 0

       

      Ex - for 07/13

      Bar 1 = 100

      Bar 2 = 102

      Bar 3  = 40 (Subtract Bar1 from Bar 2 for the previous period ie  30 -50) and add Bar 3 of previous period ie 60

       

      effectively Bar 3 is backlog

       

      How can i achieve this in tableau?