Skip to content

CategoryReports

Report on Objects and Fields

Monitoring and auditing object and field information can be a tedious Task. Going through Object Manager to an Object then clicking on Fields & Relationships and trying to scroll while waiting for the list to update takes a while (in cases where you can’t just search on field name). Wouldn’t it be great if we had a way to get information on our Objects and Fields quickly in one screen? Good news is, we can, with Reports.

Summer ‘21 Forecast Improvements

Accurate Forecasting is critical to all businesses. It allows for strategic planning, cash flow predictability and overall business guidance. One longstanding complaint has been the lack of flexibility to customize Forecasting. With the Summer ’21 release we now have the ability to create and report on Forecasts Types based on custom fields along with an improved experience to manage Forecast Types. Let’s take a look at the new capabilities.

Display Currency Values Based on the Running User of a Report

There is no “dynamic” option available in the report builder that allows a report to use the currency specified for the running user. Until this is supported natively, you can follow one of these methods in order to edit the metadata of your report so that it displays the currency of the running user. This makes it possible to manage a single set of reports in multi-currency enabled orgs.

Year-To-Date Year-Over-Year Filter Options in Salesforce Reports and Dashboards

You can build a single dashboard along with the necessary source reports and allow the running user to choose their time frame with the ease and simplicity of selecting an option from a drop down menu. Up to 50 time frame options can be predefined using this method and you have complete control over the display values for those options. Easily compare the current year-to-date (or fiscal year-to-date) to the same time frame during the previous year. You can even show trends over multiple years.

Count the Number of Date Groups in a Report Dynamically

A report request comes in asking for a calculation showing the average number of records created in a week. The time frame for this report could be set to a few different values – like last year, last quarter, or over the course of the previous two years. Ideally, the calculation would be dynamic and count the number of weeks that are present in the report results so that these time frame adjustments can be made on the fly. Using a formula field on the object and a summary formula field within a report, you can dynamically count the number of date groups shown in the report results at run time. Let’s dive into the specifics on both pieces of this solution so you can implement it in your org for your use case.

Reporting on Activities

If you’ve ever tried to create reports on the activities that your users are meticulously entering, you may have run into some perplexing behavior. We have a handful of strategies you can utilize in order to bring some normalcy to the activity object in reports. You’ll even be able to create an “Activities (Deluxe)” report type by the end of this article.

Collaboration and Sharing with Reports and Dashboards

Reports and dashboards are an integral part of every Salesforce org and are key components to uncover business insights as well as to drive actionable decisions. The consumption of the data is an important piece of their usage. To make these analyses even more useful we can add layers of sharing and collaboration. This allows us to capture different perspectives, challenge the validity or derivation of the data and make it more accessible. Next we will look at several ways to do this.

5 Ways to Use Colors in Reports & Dashboards

Reports are a mechanism for gathering and correlating data. However, people are visual learners. Adding a chart to a report or creating a dashboard allows people to easily understand the business insights that the report is providing. To take this visualization to the next level you can utilize color to help further communicate the report results and make them easier to consume. During this presentation you will learn how to set default picklist value chart colors, use conditional formatting to color code report table cells, create visual image formulas, customize dashboard themes and palettes and get creative with Analytics dashboard color schemes.