Limit # of records in a table report
I'd like to be able to run a report that shows just the top 20 results. For instance, customers - sorted by volume from largest to smallest, only returning the top 20. I can't seem to figure out how ...
Forum Discussion
In this video, QBJ shows how to use Size to rank records. It should be done as a report formula in the settings of the Table report. However, if you are dealing with a large data set you may encounter some performance issues. This is why it's suggested that you do it in a report formula vs a formula field at the table level. If there is a performance issue it will only impact that report vs the entire table. If performance is a concern you should look into alternate options. Perhaps a pipeline that will query the top 20 and copy the records to a reporting table and each time it runs it refreshes the table.
This works kind of OK. It's still not really doing what I want it to do. I can't understand why it's not an option to just limit the # of results to X.
------------------------------
Thanks,
Chris Newsome
------------------------------