0 Replies Latest reply on Mar 13, 2014 12:02 PM by amanda.stanke

    Help Conditionally Displaying a Percent

    amanda.stanke

      Hi Everyone,

       

      I'm working off of a spreadsheet that has a list of Activity ID's and whether or not they have their ROI Complete, which is a Yes/No. Here is an example:

       

      Activity IDROI Complete?
      168037Yes
      168146Yes
      171930Yes
      168542Yes
      173127Yes
      164425Yes
      168042Yes
      172939Yes
      178236No
      170332No
      170233No
      170235No
      170334No

       

      If I do a quick calculation using a Count Distinct of the Activity ID, I can see that 62% of Activities have ROI and 38% do not.

       

      I am able to display the data in Tableau in a table like this:

       

      ROI Complete?
      NoYes
      38%62%

       

      But ultimately I am trying to build a Dashboard that shows a snapshot, which only includes the Yes Percentage. So in the Dashboard, I want that section to say:

       

      ROI Complete: 62%

       

      I am not sure how to show the percentage for the Yes value only without removing the No and messing up the calculation.

       

      I'm using version 8.14.

       

      Really appreciate your help!