Forum Discussion

joschultz's avatar
joschultz
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Top 15 in a report

What is the easiest way to show just the top 15 items in a report?  Example is I want to show the top 15 products in sales for the day.  I will have hundreds of products in the data but only want the...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

    I use the Rank X measure for my products in the filter area of the visual (or whole page as needed). Then, when I add other values, there is nothing to break. I don't put the Rank X in the visual, I just use it as a filter for the page/report. In fact, I usually fill in all other information then apply it last to pull up my top 25.

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

If its all in the same table that should definitely not happen???

 

sallen's avatar
sallen
Frequent Visitor
10 years ago

Weird. So this is my table without the case description (everything working fine):

 

Without case description

And here it with the case description. All I've done to add this to the table is to drag it from the field list into the 'Values' section of the visualisation:

With case description

Thanks so much again for your help, this is really helping me understand how it all works. I think once I can work through a couple of examples I'll be able to teach myself a lot more effectively.

 

Stuart