Create a Simple Custom Report | Create Reports and Dashboards for Sales and Marketing Managers
#salesforce
#trailhead
#salestraining
#Superbadge
Create Reports and Dashboards for Sales and Marketing Managers
Lightning Experience Reports & Dashboards Specialist
Create a Simple Custom Report
Follow Along with Trail Together
Adjust Settings
Before creating the first report, you'll need to associate the role of CEO with your profile so all report data is viewable.
Click the gear icon Setup icon and select Setup.
Enter Users in Quick Find and select Users.
Click Edit next to your name and change Role to CEO.
Click Save.
Next, edit the Close Dates for all of the existing opportunities. This is done so the correct data appears when you run the current fiscal quarter report later in this project.
Click the App Launcher App Launcher icon and select Sales.
Click the Opportunities tab.
Click Recently Viewed and select the All Opportunities list view.
Select the checkbox to the left of Opportunity Name to select all opportunities.
All Opportunities list view with all records selected
Note: If you don't see checkboxes next to the opportunities, it may be because you've applied opportunity record types in this org. If so, apply the following filter to the all opportunities list view: Within the filter menu, click Add Filter Field = Opportunity Record Type, Operator = equals, Value = 0 options selected Click Done Click Save.
With all opportunities selected, rollover the Close Date for one of the opportunities and click the pencil icon.
Type in today's date.
Select the checkbox to Update 31 selected items.
Click Apply.
Note: All of the opportunities should now have today's date as their Close Date.
Click Save at the bottom of the screen.
Create a Summary Report
Time to create a new opportunity report.
Click the Reports tab.
Click New Report.
In the Choose Report Type list, click Opportunities, then select Opportunities from the list that appears.
Click Continue.
Choose Report Type
Next, you'll use the Lightning Report Builder—a visual editor for reports. The report builder screen lets you work with report fields and filters, and shows you a preview of your report with just some of the data.
Report breakdown
The Fields pane (1) displays fields from the selected report type, organized by folder. Find the fields you want using the Quick Find box and field type filters, then drag them into the Outline pane or double click them to add them to your report.
The Outline pane (2) makes adding, removing and arranging columns a breeze with a simple drag and drop feature. You can also add Bucket Columns and Summary Formula Columns in the Outline pane.
The Filters pane (3) allows you to set the view, time frame, and custom filters to limit the data shown in a report.
The Preview (4) offers a dynamic preview that makes it easy for you to customize your report. Add, reorder, and remove columns, summary fields, formulas, groupings, and blocks. The preview shows only a limited number of records. Run the report to see all your results.
Set the scope of the report using the standard filters.
Enable Update Preview Automatically in the upper-right of the Report Builder.
In the Preview pane, click the arrow next to the Opportunity Owner column heading, and then select Group Rows by This Field.
Click the Filters pane.
Ensure Close Date is set to Current FQ.
Click Opportunity Status and select Open and click Apply.
Change the report columns as required.
Click the Outline pane and click the X next to the following column headers to remove them:
Owner Role
Fiscal Period
Age
Created Date
Next Step
Lead Source
Type
Add a summary field.
Click the arrow Down arrow icon next to the Amount column heading.
Select Summarize.
Click Sum.
Save the report as Opportunities by Rep in the Global Sales Reports folder.
Click Save & Run, and then complete the Save Report details:
Report Name: Opportunities by Rep
Click in the Report Unique Name text box to auto-populate the unique name. Don't worry, the unique name of this report isn't checked.
Report Description: What opportunities do reps have in the pipeline?
Click Select Folder, choose Global Sales Reports, and click Select Folder.
Click Save.
00:00 Introduction
00:38 Users
07:08 Report
Смотрите видео Create a Simple Custom Report | Create Reports and Dashboards for Sales and Marketing Managers онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Saurabh Infotech Solutions 04 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 13,665 раз и оно понравилось 67 людям.