10 Replies Latest reply on Nov 12, 2019 10:37 AM by Zen Tableau

    Single Dimension has differnt values types 'status' needs to compare data capture and count day

    Zen Tableau

      Hi All,

       

      How are you.

       

       

      Tried various ways but no luck.The scenario where I have to count dates based upon 'StatusType' like below scenario ID 100. I have Count the days between Statustask. I have attached a sample data excel file

       

      100 : Start    -  Completed = 10 days

            Begin    -  Completed = 10 days

            Begin    -  Completed = 04 days

            Begin    -  Completed = 05 days

       

      Same applies for 101 records (ID)

       

      Desired    OUTPUT    - for ID 100 only 

       

      Yellow    14    days

      Orange    15    days

      Thanks

      cs