2 Replies Latest reply on Apr 9, 2018 2:56 PM by Deepak Rai

    Group Data Dynamically

    mansi malik

      Hi All,

       

      I am stuck with an issue which seems to be very easy but not able make it work so here I am with a question:

       

      It is Claims data, each claim may have more than one transactions under it and  each transaction has a status code tagged. Per my requirement, I have taken max(Status Code) as Status and would finally need to create a status graph from this. But I am not able to achieve this. For example:

       

      Status     Claim Id

      0               A

                       B

                       C

      1               D

                       E

      2               F

                       G

                       H

                        I and so on....

       

      Now I want Tableau to give me something like this...

      Status     Claim Count

      0               3

      1               2

      2               3

       

      But I am not able to calculate the count. I have attached the final view which I want to create from this.