In a recent campaign led by our organization that works with Salesforce CRM, the sales team generated plenty of leads. The campaign lasted one month, and the sales team asked to group the generated leads in a weekly format so that they could analyze week-wise performance throughout the campaign.
As a solution for that, I created a lead report and grouped it by week. Here, I will explain to you what is grouped by week or quarter in Salesforce, and then we will see step a step-by-step explanation to create Salesforce report group by week and quarter.
Salesforce Report Group by Weeks
In Salesforce, the group-by-week filter is a feature in Salesforce reports that allows us to group records based on week dates. Grouping the data in a weekly format helps us observe the changes that occur every week.
Suppose we have a created date field in the opportunity object. When we group this date in week format, we can view the record of created opportunities in week date format. For example, if the start date of the week is 01/01/2024, then the last date will be 07/01/2024.
Create Salesforce Report Group by Week
In this example, we will create a Leads report, and I will explain how to group the records in a weekly format. We will filter the records with the Created Date field and apply the filter report Group by Week.
1. Go to “App Launcher” -> Search “Reports” -> Click on Reports. Then click on the New Report button.
2. Go to All category -> to select a report type; search “Leads,“ you can search on which object you want to create a report. -> Select Leads.
3. Now, remove the Default Filter to display all records in the report. To do so, go to the Filters tab and apply the following filters.
- In the Show Me field, select All Leads.
- In the Created Date field, select the Range field as All Time.
4. After that, click the Outline tab to select the date field to group. Then, search for and select the date field Create Date in the field Group Rows.
Now, the report data will be grouped in the row Create Date.
5. Now, we want to group the report by Week. To do that, click on the dropdown menu in the Create date column and select Group Date by -> Calendar Week.
6. After applying the above filter, the data will be arranged in a weekly format, as shown in the picture below. Now click on the Save & Run button.
In this way, we successfully grouped a report by week in Salesforce, where we grouped the report data based on the weeks.
Salesforce Report Group by Quarter
In Salesforce, we want to display records in a manner of organizing your data based on quarterly intervals within a fiscal year. This is useful for analyzing trends and performance over each quarter, helping you understand how metrics such as sales, revenue, or opportunities vary throughout the year.
Create Salesforce Report Group by Quarter
In this example, we will create an Accounts report, and I will explain how to group the records in a Quarterly format. We will filter the records with the Created Date field and apply the filter report Group by Quarter.
1. Here, we will create a New Report. Go to All Category -> to select a report type and Search Accounts. You can search for which object you want to create a report. -> Select Accounts.
2. Now, remove the Default Filter to display all records in the report.
3. To add a group row, click on the Outline tab in the left sidebar, then go to the field Group Rows, and search, then select the date field Created Date.
Now, the date field Created Date will group the dates of records in a row.
4. Click on the dropdown of the group row Created Date, and in the options, select Group Date by -> Calendar Quarter.
5. After applying the above filter, the data will be grouped in quarter format, as shown in the picture below. Now click on the Save & Run button.
In this way, we successfully grouped a report by quarter in Salesforce, grouping the report data based on the respective quarter.
Conclusion
In this Salesforce tutorial, we learned Salesforce Report Group by Week and Quarter by using the above examples, which involved creating reports in Salesforce. In those reports, we grouped the date field in the Week and Quarter format.
In addition, we have also learned about grouping the reports in the month and year format to organize and group the records in the report table.
You may like to read:
- Salesforce Report Group by Month and Year
- Filter Out Blank Values in Salesforce Reports
- How to Subscribe or Schedule Reports in Salesforce?
- How to Create Row Level Formula in Salesforce Report
I am Bijay Kumar, the founder of SalesforceFAQs.com. Having over 10 years of experience working in salesforce technologies for clients across the world (Canada, Australia, United States, United Kingdom, New Zealand, etc.). I am a certified salesforce administrator and expert with experience in developing salesforce applications and projects. My goal is to make it easy for people to learn and use salesforce technologies by providing simple and easy-to-understand solutions. Check out the complete profile on About us.
