1 2 Previous Next 15 Replies Latest reply on May 7, 2013 9:02 AM by Ryan Johnson

    How do i create a calculated field based on text fields?

    Ryan Johnson

      Sorry - Tableau newbie here, so I apologize in advance!  I need to create a calculated field (I presume) expressed as a percentage, but using text fields.

       

      Specifically, I'm trying to write a won/loss ratio using these table entries: WON, COMPLETED, CANCELLED, LOST.  The ratio = WON or COMPLETED divided by (WON,COMPLETED) + (CANCELLED,LOST).

       

      But I can't seem to figure out how to tell Tableau how to take the number WON or COMPLETED and divide it by the other factors. 

       

      Any help or comments appreciated!

        1 2 Previous Next