Blog

The long wait is finally over. The Salesforce Summer ’20 feature releases and updates are now implemented! To give you insights on how those new features work, we will be featuring the recent updates related to Reports and Dashboards in this blog series.

Do you think one of your upvoted ideas made the cut? Here’s an overview of some of the Summer ’20 report update features:

REPORTS & DASHBOARDS

  • Filter Knowledge Reports by Category
  • Attach .csv Files to Report Subscriptions (Beta)
  • Enable Enhanced Folder Sharing (Update)
  • Work with up to 5 Unique Fields in Report Row-Level Formulas
  • Build Reports Based on Price Book Entries
  • In Salesforce console, report links open in a new subtab
  • Discover Details About the Flows You Build with the Screen Flows Report

Reports and Dashboard Part 1: Filter Knowledge Reports by Category

In this release, you can now filter knowledge reports by category. See this new feature in action in this sample user case:

Rock & Roll Co. is one of the leading providers of Customer Support and Services in the shipping line industry. Thanks to the comprehensive public knowledge base implemented by its Salesforce team, the customers and agents of the company can efficiently get the information they need to solve cases using articles!

To improve customer support, the System Administrator thought of providing each of the company’s Regional Support Directors with a visual summary of the Top 3 Articles with the most number of cases. This way, the Support Directors will know what areas they should prioritize for their next knowledge base and service enhancements.

To do this, the admin created first a new Knowledge report type:

This report type allows report creation from all Knowledge Articles.

And since Rock & Roll Co. is currently operating in the APAC (Asia Pacific) and US (North and South America) regions, with services categorized in four types (Bulk, General, Special, and Passenger), the admin preferred creating a separate report for each region:

With the Knowledge report all in place, the admin then added appropriate report filters to return the accurate number of records using a brand-new feature called ‘Category Filter’. This allows using four different operators to get the desired Knowledge articles:

  • at — returns Knowledge articles in the selected category
  • above — returns Knowledge articles above and in the selected category
  • below — returns Knowledge articles below and in the selected category
  • above or below — returns all Knowledge articles above, below, and in the selected category

Category Filters can be found from the Filters dropdown list.

Along with this, the necessary knowledge article should be fetched by region. The admin did this by creating two separate reports for the APAC and US. This becomes doable because of a Category Filter added to each report, refining the results and displaying only the required data. The two filters are defined similarly, except for the value of the Region:

One report is filtered by the ‘US’ region and the other one is filtered by the ‘APAC’ region.

Aside from the ‘Region’ category, the admin can also include the ‘Services’ category to filter the returned records. This can contain all the services or just the main ones offered per Region. Now, there are two reports that return the ‘Case Association Count’ of the published articles for the closed cases. With the help of a Category Filter, analyzing the data from Knowledge articles became easier:

Multiple categories can be added to a report.

However, this new feature is only available on report types that include the Knowledge object, such as Knowledge Articles or Knowledge with Cases.

And to seal things up, the admin added the chart and table components in the Service Executive Dashboard. This is to visualize the data gathered, giving the Support Directors a more convenient view and access of the report.

In this dashboard, the donut charts visually display the percentage of closed cases associated with each of the top three articles. Additionally, the table components below show the title and the number of cases associated with the top three articles. This simple dashboard can be used by the Support Director to understand how helpful the self-service knowledge base is when it comes to closing cases and what issues tend to be resolved the most through Knowledge articles.

And that’s how you filter knowledge reports by category. By doing so, you can visually present data to help you and your colleagues harness it for your next business decision. This is just one of the cool new features of Reports and Dashboards.

Can’t wait to see the other updates? Stay tuned to this series as we’re going to feature that on our next blog installment!

What Certification are you studying for now?

Focus on Force currently provide practice exams and study guides for nine certifications

Focus on People: Cary Walkin – Making the Impossible Possible

As an accountant, Cary primarily uses Excel. After taking a new role as a Financial Systems Manager, he was introduced to Salesforce to do the job more efficiently. This pushed him to take Salesforce certifications, making him an in-house expert of the platform. He also shared here his preparations for the exam, the challenges while learning the platform, and how he leveraged his certifications to establish stronger process alignments across the board.

Focus on People: Cary Walkin – Making the Impossible Possible

Batch Apex in Salesforce (Real World Scenarios)

Salesforce has introduced numerous declarative automation tools and features in recent times, significantly decreasing the reliance on Apex code. However, despite these advancements, developers still rely on Batch Apex when dealing with a high volume of records.What is Batch Apex?Batch Apex is used for processing a large number of records. Since the code is run asynchronously, the records are processed within platform limits. Once the batch Apex job is invoked,… Read More

Batch Apex in Salesforce (Real World Scenarios)

Focus on People: Mark van Voornveld – Taking the Big Shift: From Microsoft to Salesforce

Mark van Voornveld is an IT professional with a 30-year career built around Microsoft Azure Stack and Dynamics. While relatively new for him, he chose to transition to Salesforce, seeing it as a fresh path to take and a good addition to his expertise. Here, he shared his professional journey, reasons for this transition, and his adjustments to a new CRM and the essential, non-technical skills that make an IT… Read More

Focus on People: Mark van Voornveld – Taking the Big Shift: From Microsoft to Salesforce

Salesforce Einstein: 24/7 At Your Service!

Sugar, spice, and ‘everything nice’? Salesforce almost has it all now that Einstein, the smart CRM assistant, is already at our service. Einstein was first introduced as part of the Salesforce Spring ‘17 release and is now a component of Salesforce core cloud products. This innovation was built for the Customer Success Platform to break down the complexity of artificial intelligence technology, helping customers leverage AI capabilities. It must be… Read More

Salesforce Einstein: 24/7 At Your Service!

Salesforce: How It Started and How You Can Be Part of the “Ohana”

How did an innovative cloud platform become one of the world’s best CRM solutions?Salesforce has been bringing companies and customers together for over two decades. It began as a Software as a Service (SaaS) company. Salesforce is now the fifth-largest software company in the world. They leverage cloud technology and build a variety of applications for businesses to help better give them key insights into their services through analytics and… Read More

Salesforce: How It Started and How You Can Be Part of the “Ohana”

Apparent Gender Bias Hampers Women’s Career Progression in the Salesforce Ecosystem

by Zoë Morris Flexible and home working are the most desired employment benefits among women working with Salesforce, but their entitlement to these benefits is actually lower than their male counterparts. This is having an adverse effect on gender representation in the Salesforce ecosystem.Mason Frank’s annual salary survey is the largest independent exploration of Salesforce culture. As well as being useful for benchmarking salaries and learning the best education and… Read More

Apparent Gender Bias Hampers Women’s Career Progression in the Salesforce Ecosystem

4 Salesforce Exam Writing Tips to Achieve Salesforce Certification Success

by Cary Walkin Do you have your eye on a Salesforce Certification to advance your career? Perhaps it’s your first certification. Maybe you’re challenging yourself with a difficult certification. I’m a 6x Salesforce Certified professional who has had a career full of exams, and the tips in this guide have helped me and my team pass all of the Salesforce Certification exams that we’ve written. I wrote this guide to… Read More

4 Salesforce Exam Writing Tips to Achieve Salesforce Certification Success

Top 10 Tips for Taking a Salesforce Online Proctored Exam

So you’ve decided to take a Salesforce exam? Congratulations! You’re now one step closer to becoming a Salesforce certified professional. But with the COVID-19 outbreak, taking onsite examinations at a testing center are now not possible.Undergo a safer, more convenient option and take an online proctored exam instead. This is now the perfect time to take these tests especially if you’re worried about the online testing requirements. Because of the… Read More

Top 10 Tips for Taking a Salesforce Online Proctored Exam

Focus on People: Damian Galbally – Maximizing Sales with Salesforce

Damian Galbally became curious about the potential of Salesforce when he was met with some limitations while using it. In this interview, he talked about the challenges he had experienced and how these challenges had shaped the way he helps SMEs maximize Salesforce as a consultant for small businesses today. My name is Damian Galbally, and I am a consultant. My first contact with Salesforce was with a former company I… Read More

Focus on People: Damian Galbally – Maximizing Sales with Salesforce

Get Certified: 91% of Salesforce Professionals Consider Certifications a Factor Impacting Earning Potential

When you work with a technology as fast-moving as Salesforce, it’s incredibly important to read independent research on the ecosystem to ensure you’re steering your career in the right direction.As a Salesforce education provider, it’s really helpful for us to find out where a typical professional struggles in their learning journey and how we can help. Focus on Force was recently featured in the 2019/20 Mason Frank Salary Survey as… Read More

Workflow Rules vs Process Builder – When to Use What

Before diving into the differences between Workflow Rules and Process Builders, I do want to call out that in some Trailheads from Salesforce, there have been callouts to moving away from Workflow rules entirely. Be that as it may, Workflows are still up and running and in some cases can be simple, faster, and easier to apply than a Process Builder. However, please do keep this in mind if you… Read More

Focus on People: Jim Vineyard – From Zero to Hero

Jim Vineyard knew nothing about CRM before he explored Salesforce, as part of an account he took on for Customer Service. Working with his son in the same company, doing the same job, he navigated through Salesforce and learned a whole new world of custom CRM, and Customer Service functionalities, never before possible for him, in the last decade of his career. I began with Salesforce as a result of the… Read More