IT & Technology

Salesforce: How to Get Daily Record Creation Counts Using SOQL

Explains the specific method and query syntax to aggregate and retrieve daily record creation counts for Accounts and other objects using SOQL from the Salesforce Developer Console. You will understand the procedure for convenient data analysis using the GROUP BY clause.

How to Get the Daily Record Creation Count Using SOQL in Salesforce

Open the Developer Console.
Open the Query Editor tab.
Paste and execute the following SOQL query.

1
select day_only(createdDate), count(createdDate) from account group by day_only(createdDate) order by count(createdDate) desc limit 10

Change account to the name of any object you want to query before executing.

Reference

Is there a way to group by the date portion of a datetime field in SOQL?

comments powered by Disqus