1 Reply Latest reply on Sep 19, 2017 10:28 PM by Esther Aller

    Area chart showing the totals of statuses through time

    Edmund Gentle

      I want to create a stacked area chart showing the status of a set of values over time. Essentially, for each record, I have a hotlist date, an expiry date and a blocked date:

       

      Hotlist DateExpiry DateBlocked Date
      2016-05-062018-01-01NULL
      2016-10-102018-01-012017-03-02
      2015-08-232017-06-012017-01-07

       

      I want to show the status of each record on a cumulative stacked area chart.

      Status - Hotlisted = Date>Hotlist date AND Date<Expiry AND Date<Blocked

      Status - Expired = Date>Expiry

      Status - Blocked = Date>Blocked AND Date<Expiry

       

      Therefore the status of each record changes through time depending on the dates in the table.

       

      Tableau v 10.3

       

      I'm not sure if I've explained this well - but any help is much appreciated!

       

      Many thanks

       

      Edmund