Any trick to make Count Filtered work with External Database?

I have tried the Filtered Count with Airtable, and I found a thread that suggests Filtered Count doesn’t work with external data in Airtable.

However, for my app, I need to visualise individual user’s orders over time, so I really need this function to work.

Is there any trick to make it work with External Database in Airtable? If Airtable is not the right choice, is there another platform would work with Filtered Count? Has anyone tried Filtered Count with Xano?

Hello, I would really appreciate anyone who has managed to solve this.

I have been thinking about this, within Airtable, you can group items with similar value. If
Filtered Count doesn’t work with Airtable, is there anyway we can try get the Sum values of the grouped record in Airtable instead?