Share My Creation SithasoDaisy: PocketBase - Mini CRM WebApp Source Code @ $5.00

Mashiane

Expert
Licensed User
Longtime User
Finding the top customers.

In pocketbase create a collection with a type of view. Use the specified query.



B4X:
select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.customerid from minicrm_sales group by minicrm_sales.customerid order by totalsales DESC
 

Mashiane

Expert
Licensed User
Longtime User
Finding the top products.

In pocketbase, create a new collection with a type of 'view', use the specified query.



B4X:
select minicrm_sales.id, count(minicrm_sales.quantity) as totalqty, sum(minicrm_sales.totalprice) as totalsales, minicrm_sales.productid from minicrm_sales group by minicrm_sales.productid order by totalsales DESC
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…