Limit rows to a certain number e.g. top 20

Is it possible to limit the amount of rows in a table view for use in a chart?
E.g. I want to see my top 20 accounts based on sales value.
However when I create a chart, based on sales value, I cannot limit the results to only the top 20.

Hmmm, I don’t have the answer for you on how to quickly or easily get the top 20 records into a chart, but I do know that the Record List Block will let you display a list of the first X number of records based on however you sort your data.

One option is to write a script in the Scripting block that marks those top 20 records (perhaps via a {Top 20} checkbox field). With a view that only shows those marked records, choose that view from the Chart block. If you’d like help with the script, let us know!

1 Like

Thanks @ScottWorld / @Justin_Barrett.
The record list is probably the closest to what I’m looking for.
I ended up looking at what the sales value is at row 20, and set a filter where sales value > than just below this number to give me the top 20.

1 Like

Great to hear it! Glad I could help! :slight_smile: You also could just sort your records from highest to lowest, without worrying about the filter.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.