2 Replies Latest reply on Oct 7, 2015 9:58 AM by Ramon Martinez

    Trying to calculate Legend Occurrance Totals

    Theresa Presson


      Does anyone know if there is a Tableau function that will display the Total Number of Legend Occurrances?  I have a workbook which  displays lead time metrics that represent # of days difference between 2 dates.  If # of days difference is less than or equal 5, I have a legend color = GREEN; If # of days difference is greater than 5, I have a legend color = RED. I need to calculate the total # of GREEN occurrences vs RED occurrences.  For example, there are 10 occurrances of GREEN (where the # of days difference is less than or equal to 5) and there are 2 occurrances of RED (where the # of days difference is greater than 5).

       

      I could setup calculated fields to do this, but I'm wondering if there is a built in Tableau function that does this.

       

      Thanks in advance for your help!

      Theresa