Formulas Superbadge Unit
--------------------------------------
Evaluate Report Data with Formulas
Learning Objectives
In this project, you’ll:
Run reports to calculate averages, sums, and maximum or minimum values.
Use a formula to apply a discount to selected opportunities.
Learn about measuring values over time with PREVGROUPVAL().
Find proportions by comparing group total to report grand total with PARENTGROUPVAL().
Introduction
Data summaries are a powerful feature of the Lightning Report Builder. With summaries, you can aggregate values, which empowers you to get more out of the numerical data in your report without even adding a filter.
Summarize Report Data
Lance Park, a sales rep at Ursa Major Solar, has been looking for ways to optimize the company’s profit margins. He wants to see how the sum of expected revenue from all of Ursa Major’s opportunities compares to the actual revenue they can expect to see. He also wants to see average sum and expected revenue for each individual opportunity. With data summaries, Lance can create an opportunity pipeline report and summarize the Amount and the Expected Revenue columns to find the average and sum.
Create an opportunity report.
Click Reports, then New Report.
From the Choose Report Type menu, search for and select Opportunities.
Click Continue.
To open the Filters pane, click Filters.
Click the Close Date filter, set the Range to All Time, and click Apply.
Group the report by Stage.
To open the outline pane, click Outline.
Under Group Rows, from the Add group… lookup, search for and select Stage.
In the preview pane, find the Amount field and click Down arrow, navigate to Summarize, and select both Sum and Average.
Click Down arrow next to the Expected Revenue column, navigate to Summarize, and select both Sum and Average.
Click Save & Run.
Name the report Opportunities by Stage.
Set the report's unique name to OPPORTUNITIES_BY_STAGE.
Click Save.
#istampers #tutorial #salesforce #Superbadge #Trailhead #quiz
15 окт 2024
