Feature Requests
Share ideas, discuss and vote on requests from other users in community
 

Top 10 Clients by Income Report - add date filtering

kurieuo shared this idea 4 years ago
Under Consideration

The Top 10 Clients by Income Report is very interesting to see where money comes from.

I would like to suggest the addition of date filtering, so we can see our top 10 clients for the year or month, etc. Right now it is their "lifetime value", the amount is what they have paid ever as a client.

I have noticed that older clients that are no longer spending as much money but did in the past are on my report.

Comments (3)

photo
1

This is a great update for this report. It would be helpful.

It would also be nice to see the top 20, 30, 40, 50, 100, 200, etc.

photo
1

Both ideas are grateful

photo
1

This query did this for you...

  1. SELECT tblclients.id,datecreated,firstname,lastname,companyname,SUM(tblaccounts.amountin) as total FROM tblclients INNER JOIN

    tblaccounts ON

    tblclients.id = tblaccounts.userid

    GROUP BY tblclients.id

    ORDER BY total DESC

    LIMIT 10