View Source Ash.Error.Query.NoComplexSortsWithKeysetPagination exception (ash v2.9.19)
Due to the filter-based implementation of keyset pagination, it cannot be used with sorts on calculations.
We could solve this problem by making the keyset only be the primary key of the record,
and then fetching that value loading the calculations/aggregates that we need. If we do this
we should either: 1.) make it a new pagination mode or 2.) add an option like
mode: :strict | :fetch
to pagination options.
Let me know if you're reading this and want to help implement it.