Can't seem to sort data from Big Table rollup values

Looking to make a leaderboard using Big Table rollup values. However I can’t seem to sort the data grid by the rollup value. It doesn’t show up under the sort function for the component. It does however show up under the group function…so close, yet so far. Any work arounds? I’m hoping this feature is added in the next month or so…my client’s app hinges on the feature so I can have the highest values at the top of the leaderboard! :grimacing: :slight_smile:

mmm, sorting Big Tables by computed columns is not supported, and as far as I am aware there are no plans to support it in the near term future.

The only suggestion I can make is to see if you can do something with a Query column.

Thanks Darren for the quick reply! Maybe its just a minor tweak to get sorting by computed column up and going for BT data? The group function currently can utilize the computed column so may not be too big of a leap? This would be amazing and the final piece to scalability for my client’s app (something I’ve been telling him for 2 years is coming as his user base has steadily grown…so close!) @david

Just my guess, but seems like grouping allows working on the existing set of data, whilst sorting involves more computation on the user’s device.

Please correct me if I’m wrong, but my interpretation is that most of the Big Tables’ limitations are put in place to protect the device from running through a huge amount of computation which it might not be able to handle.

1 Like

Thanks @ThinhDinh. I’ve heard something to that effect as well. I’m curious too if sorting is more computation than grouping. Hoping and praying and crossing fingers for the sorting feature! This would be the final touch for this app.

1 Like

I added sorting of Big Table computed rollup columns into the feature request page. Please vote! @ThinhDinh @Darren_Murphy The BT rollups are so powerful but the value is locked away and projects are on hold until we can make sense of the data and sort it. Needing this feature asap! Need Sorting of Big Table computed columns!