Getting Custom Reports from databases

Hello, am creating an app for my users(employees) about money lending business where I want them to be viewing different reports on their screens that include Defaulters, Completed clients, Missed payment clients, Progressing clients, and new clients. The databases am using are, Users, Client database that stores information about clients, and loan payment where users update the client who has paid. How can have those custom reports (Defaulters, Completed clients, Missed payment clients, Progressing clients, and new clients) in different screens

Hi @MusiimentaNobert ,

To show the list with different status, there should be status field in users collection or other related collections.

It could be combination of status with other indicators to make up the intended report.