Skip to main content

Filtering top X values

  • November 11, 2020
  • 2 replies
  • 6 views

Is there a way to see only the top X values in a view?

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9767 replies
  • November 11, 2020

This can be done with the record list app, but ufortunately, apps have no effect on views.


Forum|alt.badge.img+19
  • Inspiring
  • 3263 replies
  • November 12, 2020

Sure. Use a script action to periodically rank items using fields of your choice. Sort the data (in the script) based on the rank. Then number the items in yet another field. Create a view that orders the items 1 to x… and filters for rank numbers <= x.