3 Replies Latest reply on Oct 13, 2016 1:47 PM by Keshia Rose

    Change of Status through time

    Siddharth Patil

      Hello Everyone,

       

      I was experimenting something and wanted to know if anyone has tried a outcome.

      I have a table which has 3 columns: Member ID, Date and Risk Category. I have created date parameters End Date 1 and End Date 2. I was wondering if I can create a view that can count how many members Jumped from Low risk to Low risk, Low Risk to Moderate risk, Low Risk to High risk, similarly Moderate to Low Moderate and High, and High Risk to Low Moderate and High on End Date 2 Compared to End Date 1.

       

      I am attaching a Sample Data set and the Workbook.

       

      If this is not possible directly in Tableau, is there some way I can achieve this tweaking the Data set or some other work around for this?

       

      Regards

      Siddharth