I just want to do a query of a custom object to sum the sales per day for every user. The idea is to show how much every person has sold, even if the result is zero I need to show that value.
Example User: John/ SUM= 10$ User Peter/ SUM= 0$ User Edward/ SUM=5$
This query return just the values that have a value in SUM (John and Edward) and I need to show the result for all the active users.
This is the query:
SELECT Owner.Name c, SUM(Total__c) s FROM Order__c WHERE (Owner.Id
IN:ActiveUsers) AND CreatedDate = Today group by Owner.Name order by Owner.Name ASC
ActiveUsers is a List of Ids which is correctly filled, in my case has 23 active users.
How can I show all the sums for every user and not like in this query that just show me if the SUM has a value.
Thanks a lot.