It’s not exactly a workaround, but something we’ve done with Airtable is to create a separate table with summary statistics describing the original table. It can calculate numbers such as the total count of records, and counts for a few subcategories (eg location=France), the maximum timestamp among the records, etc. In Softr, these summary statistics get displayed in a ‘Summary cards block’ that appears above the table.
Setting it up was somewhat tricky, involving linking records between the original table and the summary table. Here is an intro: All You Need to Know about Airtable’s Rollup Feature (in 2024) - Bannerbear
And in the future, with a SQL backend this kind of thing should be possible. Another reason to look forward to Softr supporting SQL data sources.