+20Good day.
I was tasked to give the following:
“Ideally I would like to see the top 15 and the bottom 15 courses delivered per year. So maybe all courses that have a number of time delivered and then a section with all the courses that had no delivery in 2025.”
Below, I’ve grouped a grid element by first the year, and the times a course delivered, to at least sort it out. How, would you all suggest a “pretty” way of achieving the request?
+31I’ve set up a top 2 display, does this look right? If so I’ve set it up here for you to check out
Starting data:
Output:
The idea is to create a new ‘Year’ field where we link up all the relevant records, and then we use a rollup field to get the highest value:
We then pull that back over into the Deliveries table to use it to identify which has the highest for that year:
Then, in the Year table, we use a rollup to determine the second highest by filtering out the highest, and we then pull that over to Deliveries to identify the second highest. This process can then be repeated till you get the top 5
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.