3 Replies Latest reply on Sep 16, 2016 3:40 AM by sunil bhagavath

    Top 3 in N data of string counts

    sunil bhagavath

      Hi,

         Am trying to built a report based on tickets being opened and closed in a state every day. I have built it using tableau but am stuck in a process. Below is my screenshot

      this is what i have so far

       

      Ticket.JPG

       

      The data data is as attached in the excel file. i want highlights both in the map and tooltip as well

      What i require is that i want to highlight the top 3 states and bottom 3 states getting the tickets everyday filter based and i want a description in the tool tip as well regarding it all this in map

      And in the tool tip i want a statement saying that this is a high hitter state and this low hitter state. and if there is many open tickets in a state i want to highlight it in red and low in green inside the tool tip

       

      The problem is that am not able to disguise between them as all of them are strings and not numbers.

       

      I would really appreciate any help regarding this. Thanks in advance