12 Replies Latest reply on Mar 25, 2015 12:07 PM by Cory Bullard

    2 questions

    Cory Bullard

      I created a report that has a ranking in it.  And it's grouped by date...for example:

       

       

      Month of Month of Date Keyword Top 10 Rank Position
      December 2014 naperville storage 1.00 13.00
      self storage union nj 2.00 13.00
      storage garden grove 3.00 16.00
      storage units in watertown ny 4.00 19.00
      mckinney storage 6.00 40.00
      rv storage dallas 5.00 32.00
      corpus christi storage 7.00 45.00
      cape coral self storage 10.00
      fl storage unit 9.00 52.00
      denver self storage 8.00 48.00
      January 2015 naperville storage 2.00 13.00
      self storage union nj 1.00 10.00
      storage garden grove 4.00 22.00
      storage units in watertown ny 3.00 20.00
      mckinney storage 5.00 33.00
      rv storage dallas 6.00 35.00
      corpus christi storage 9.00 50.00
      cape coral self storage 7.00 37.00
      fl storage unit 8.00 43.00
      denver self storage 10.00 54.00

       

      But, how do I get it to sort the top 10 in order within each grouping?  When I set up the sort...December's data will sort the top 10 in order but January won't.

       

      Also, when I export it to excel....how do I get rid of the decimals during the export.  The decimals aren't showing in Tableau.