How to sort from a sum of related data

[theoakistopoulos]

Hi there,

I’m trying to sort data from a related sum.

It goes like this :

Repeating Group of allocations > allocation’s project > project’s allocations (list) > each item amount > sum.

I’m trying to sort this allocation RG from the total of their parent project allocations’ amount sum.

Do you know a way of building this?

Maybe using List shifter? cc @keith

Thank you

[keith]

Yes, if you can construct the numeric list you want to sort on, List Shifter or Floppy can do that sort (the interface to either is somewhat different).

There are some recent discussions of this type of sorting in the List Shifter thread. For a discussion of how Floppy can do this, see:

FLOPPY: Plugin for localStorage, sessionStorage, IndexedDB storage, List Creation/Manipulation, Iteration, and More! Now with even more video docs!

MORE FLOPPY VIDEO DOCS: Here’s a video talking about a not-uncommon problem: How can we sort some list of Things based on the number of items in some list-type subfield? (Heck, how can we even get a :count for each of those fields!?) Floppy’s “Utility: Count Each Field/Sort Action” helps to solve this. (Note: In the last part of this video, I found a little bug with using “Custom Count List” and fixed it, but that fix is in Floppy version 1.8.9 which for some reason is under review with Bubbl…

[keith]

NOTE TO SELF: Floppy’s Count Fields/Sort action currently can construct a “sort by” list by counting the number of entries in some field, but it might be useful (if the field in question is numeric) to add options to take not the count of entries, but their sum/min/max/avg as an option…

[wantspawnterm]

Hi @Keith, I just purchased Floppy in the hopes of addressing exactly this. Please consider adding a sum option for numeric fields in related entries!