Skip to content

AuthorAaron Crear

Aaron is Founder & Principal at Hat-Trick Consulting. He works with companies around the world to help them achieve their Salesforce goals through administration, development and training services. A former sales director, Mr. Crear has extensive functional and technical expertise translating business requirements to technical solutions. Aaron currently holds eight Salesforce certifications including Salesforce Certified Data Architect, Sharing & Visibility Architect, Sales Cloud Consultant, Service Cloud Consultant, Community Cloud Consultant, Platform App Builder, User Experience Designer, Advanced Administrator and Administrator. He is also the leader of the Lowell, MA Admins Community Group and is a co-organizer of Northeast Dreamin’. Mr. Crear is a frequent speaker, having presented at Dreamforce, Big Sky Dreamin’, Czech Dreamin’, dreamOle’, Florida Dreamin', French Touch Dreamin’, London's Calling, Midwest Dreamin’, North Africa Dreamin', Phillyforce, Snowforce, Southeast Dreamin’, True North Dreamin, YearLeadin’and Salesforce World Tours.

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.

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.