8 Replies Latest reply on Nov 14, 2017 11:07 AM by Tyler McDonald

    How do I keep track of how many consecutive false values have occurred in the past months? Tableau 10.2.0

    Tyler McDonald

      Hi all,

       

      In Tableau, I have a list of months that are each related to a separate value. Example:

      MonthBoolean
      JanuaryTrue
      FebruaryTrue
      MarchFalse
      AprilTrue
      MayFalse
      JuneFalse

       

      I would like to create a calculated field that gets how many consecutive falses have occurred in the current and past months. Example:

      MonthBooleanCount
      JanuaryTrue0
      FebruaryTrue0
      MarchFalse1
      AprilTrue0
      MayFalse1
      JuneFalse2

       

      I was trying to use something like the LOOKUP function, but I couldn't figure it out. Any help would be greatly appreciated! Thanks!