Create a report based on Data

Just wondering what the best way to create a report based on the Database data would be.
Basically a query.
Wanting to generate a report daily or weekly.
Pulling data like items sold, transactions and so on

Doesn’t seem to be an easy way to do this.
Was thinking I might have to export all records constantly to a database. And then query that

Hi @rkeehan welcome to the forums!

If this report is just a screen within your app there are some great ways to easily set this up.

You can us use the “count” feature to display these stats for any collection you wish.