Salesforce Reports Archives - gettectonic.com - Page 2
Summary Formulas and Row Level Formulas
22Apr

Summary Formulas and Row Level Formulas

Salesforce report formulas serve various purposes, from grouping records to performing calculations and comparing data. In the Salesforce Report Builder, you’ll encounter two distinct types of formulas: Summary Formulas and Row-Level Formulas. Although they may sound similar, they serve different functions. Summary Formulas operate across multiple records, displaying their results at the bottom of a column. Conversely, Row-Level Formulas pertain to a single record and display their results directly on the corresponding row. Let’s dip into examples of both Row-Level and Summary Formulas to understand their applications in Salesforce reports. Example 1: Total Opportunity Amount Suppose your boss requests a report showing the total Opportunity Amount broken down by Country. In this scenario, you wouldn’t require a Summary Formula field. Instead, simply select the Opportunity Amount field and check the SUM checkbox. If you include a grouping based on Country, the report will automatically generate a summary line. Example 2: Average Monthly Case Volume for a Specific Product Now, imagine the support team asks for a report indicating the monthly average of Cases for a specific Product over the past year. Here, you’d utilize a Summary Formula. Ensure the Product field is set as a ‘Group By Row’ field, then select Summary Formula from the Columns drop-down. Create the formula by dividing the Record Count by 12 (the number of months in a year), and assign a column name, such as “Monthly Avg Cases.” Example 3: Checking Field Value Matches For another scenario, let’s say you’re tasked with verifying that at the Case level, the Billing State matches the Shipping State of the associated Account. With Row-Level formulas, you can accomplish this without creating a new field. Add a Row-Level Formula from the Columns drop-down, then create an IF statement comparing the Billing State to the Shipping State, resulting in either 0 (not matching) or 1 (matching). It’s valuable to note some considerations regarding Row-Level formulas, such as the limitation of one Row-Level formula per report and a maximum of five referenced fields. Additionally, Row-Level formulas cannot be used for cross-filters or buckets. Refer to Salesforce documentation for more details on restrictions. In conclusion, understanding the distinction between Row-Level and Summary Formulas empowers you to leverage the appropriate formula type effectively in Salesforce reports, optimizing your data analysis and decision-making processes. Like Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
April 22, 2020in Salesforce, Salesforce Development Services, Salesforce Optimization
Salesforce Document Generation
18Jul

Generating Documents in Salesforce

Salesforce document generation poses a challenge for businesses, given the intricacies of integration involved. Fortunately, a variety of tools are available for generating documents in Salesforce, and Tectonic is well-equipped to assist in their successful implementation. Salesforce Industries Document Generation empowers businesses to craft and manage accurate documents linked to standard Salesforce objects, encompassing contracts, opportunities, orders, quotes, and custom objects. For a more dynamic approach, Salesforce OmniStudio Document Generation facilitates the creation of documents using Microsoft Word and Microsoft PowerPoint templates. These templates can incorporate values from any JSON-based data within the text, including data sourced from various Salesforce objects. This versatile tool enables the generation of contracts, proposals, quotes, reports, non-disclosure agreements, service agreements, and more. Salesforce Industries Document Generation seamlessly integrates with Vlocity Insurance, Vlocity Health, communications, media, energy, utilities, government, and beyond. Vlocity Analytics, another valuable component, offers pre-built measurement tools that seamlessly integrate with Salesforce Reports, Dashboards, and Einstein. The Salesforce AppExchange boasts an extensive array of over 200 document generation tools. Your Salesforce partner can assist in selecting, installing, and implementing the most suitable options based on your business requirements. With Document Generation, you can generate contracts, proposals, quotes, reports, non-disclosure agreements, job offers, service agreements, and so on. You can generate documents using the specified sample client-side or server-side OmniScripts. You can also create your own OmniScripts by cloning and customizing the sample OmniScript to generate documents. Client-Side document generation is a synchronous process that results in a downloadable preview of the generated documents. You can generate documents from Microsoft Word (.docx), Microsoft PowerPoint (.pptx), and Web templates. These templates can include values from any JSON-based data in the text, including data from any Salesforce object. You can optionally convert the resulting documents to .pdf format. Server-Side document generation is available in both the OmniStudio Foundation and Salesforce Industries packages. Server-Side document generation is an asynchronous process that’s best for large and rendering-heavy documents and for document generation in batches. The Server-Side document generation service is secure and scalable and is hosted on Salesforce Hyperforce. The generated document is stored in your Salesforce org, and is attached to the object for which it’s generated. You can use Apex Classes, sample Integration Procedures, or a sample OmniScript to generate documents. Client-Side document generation supports Customer Community Plus, Customer Community, and Partner Community users to generate documents using client-side OmniScripts. Server-Side document generation supports Customer Community Plus, Customer Community, and Partner Community users to generate documents using the singleDocxServersideLwc server-side OmniScript. With the right licenses, Document Generation is available in the Salesforce Industries package. Metering measures resource utilization levels and throttling controls resource access and use based on defined rules. Metering measures the number of server-side documents that are generated by an org hourly and daily. The default hourly and daily limits for processing server-side document generation requests are 1,000 per org and 24,000 per org respectively. Throttling maintains consistency and resilience of the server-side document generation service by managing incoming server-side document generation requests from multiple orgs. Throttling can also prevent service degradation caused by high volume of requests at peak hours by blocking requests that exceed the default limits. The request details are saved in the Document Generation Processes entity. You can retrieve the blocked requests and later retry the server-side document generation. No matter what your specific document generation needs, Tectonic simplifies the process of getting your system up and running seamlessly, whether it’s through Salesforce Quickstarts or comprehensive implementation services. Content updated in 2022. Like1 Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
July 18, 2019in Data, Hyperforce, Salesforce, Salesforce Sales Cloud, Salesforce Service Cloud
Salesforce
21Oct

What is Advanced Reporting in Salesforce?

Cross Filters, Summary Formulas, and More: Advanced Reporting in Salesforce Salesforce comes with report types out-of-the-box for all standard objects and standard object relationships eg. “Contacts & Accounts” or “Opportunities with Products”. You can view a list of report types when creating a new report. For the custom objects we build, Salesforce also creates report types automatically. Salesforce Reporting is one of the most powerful features, used to give users many different views into their data, and for Admins to demonstrate the value Salesforce has upon the organization’s productivity. Building reports in the Lightning Report Builder, a drag and drop interface, is extremely effective – as a Salesforce Admin, you should have a solid idea of all the options available to you when reporting requirements come up. What are advanced reporting features in Salesforce? These are the tricks Salesforce power-users should know to ultimately create the reports users need – even with challenging data models – in the most efficient and scalable way (with minimal additional configuration). Let’s have a look at some of the more advanced reporting options that Salesforce offers. 1. Custom Report Types Salesforce provides out-of-the-box report types for standard objects and their relationships. When creating a new report, you can choose from a list of available report types. For custom objects, Salesforce automatically generates report types. These report types establish a “with” or “and” relationship based on whether the two objects have a Lookup or Master-detail relationship. Custom Report Types become essential when you need to report on: To create a custom report type: Bonus: You can now automatically add fields to Custom Report Types without manually adding them to each report type. 2. Cross Filters (Exception Reports) When filtering reports, Cross Filters help identify records with or without related records, creating exception reports. They are added like regular filters, using the format: “Show me — [primary object] — with/without — [related object].” Example: “Show me — Contacts — without — Campaign History.” Enhance Cross Filters with additional sub-filters to narrow down related records further. For instance, “Show me — Contacts — without — Activities — with status: ‘open’” will generate a report of contacts with no open activities. Salesforce Admins can master Cross Filters to avoid unnecessary creation of custom report types or rollup fields. 3. Summary Formulas Summary Formulas handle complex calculations at all summary levels, acting like fields once created. In Salesforce Lightning, they are referred to as Summary Formula Columns. To use them: Summary Formulas offer powerful capabilities for in-depth calculations. 4. Row-level Formulas Row-Level Formulas, distinct from Summary Formulas, are applied to single records and displayed on the row itself. An example is checking if two fields on the same record have the same value. 5. Reporting Snapshots Reporting Snapshots capture a snapshot of Salesforce records, freezing data for future reference. Commonly used for tracking Opportunity Pipeline Change over time. 6. Historical Trend Reporting Historical Trend Reporting glances back at historical field values on a specific date. Limited to certain objects and fields, it provides a targeted view of historical data changes. 7. Field-to-field Filters These filters allow the comparison of values in different fields on a Salesforce report, refining report filter criteria. 8. Stacked Summaries Stacked Summaries summarize extensive data for quick review and comparison, activated when adding fields to both rows and columns. 9. Joined Reports Joined Reports combine two reports with different report types into a single view, offering a holistic data view. 10. Report URL Hack Report URL Hacking is a technique to set filter values via URL parameters, supported in Lightning Experience. It allows dynamic filtering without the need for multiple reports, enhancing user experience. This URL hacking can be used to launch specific reports with predefined filters, adding efficiency to report navigation. Like1 Related Posts Salesforce OEM AppExchange Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more The Salesforce Story In Marc Benioff’s own words How did salesforce.com grow from a start up in a rented apartment into the world’s Read more Salesforce Jigsaw Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more Health Cloud Brings Healthcare Transformation Following swiftly after last week’s successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more

Read More
October 21, 2017in Google Analytics
  • 1
  • 2

Subscribe to our mailing list. Join our mail list to receive our newsletter

We'll keep you up to date with our latest news, insights, free resources, and much more.
Don't worry, we won't spam you.
gettectonic.com