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:


      End State A
      Start State B


      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