Can’t seem to find anyone with this problem and been cracking my skull on it…
I use airtable to manage the factory and I have 6 welding tables which I need to divide work out fairly. I would like to be able to “group” by the last 10 jobs that I gave each of the welders in order to see how to divide the work fairly (because some work is more difficult which affects the bonus that they get).
The problem is they don’t all work at the same pace, so filtering by date doesn’t give me what I would like. I would like to display the last 10 records before now, grouped by employee.
Any clever ideas? We have the pro subscription so a solution through blocks or pivot table is also ok.