13 Replies Latest reply on Jul 10, 2018 4:50 AM by n n

    Stacked bar diagram showing number of entities

    n n

      Hello, I have data on this form:

       

      Entity
      End State A
      Start State B
      1null2018-06-20
      22018-06-102018-05-25
      32018-05-20null

       

      Each entity can be in state A, state B, both or neither. All entities start in state A. "End State A" marks the end of state A (null if the entity is still in state A). "Start State B" marks the beginning of state B (null if the entity hasn't entered this state). The states can overlap.

      I'd like a stacked bar diagram that shows how many entities are in a given category (state A, state B, both or neither), on a given day.

      I have several thousand rows of entities and am creating a dashboard with a live connection.

       

      I am new to tableau and have toyed around with calculations and running sums but have not figured out how to do this.

       

      Any help appreciated. Thanks