Ultimate Salesforce Reports: bars with a cumulative line in one report chart

The need to represent data visually using line chart showing cumulative values on top of a bar chart showing discrete values is almost universal. This can be easily verified by the amount of questions on the success community and the... Continue Reading →

Featured post

Custom dynamic “date range filters” in Salesforce reports

**Introduction** This post is about overcoming one of the limitations of Salesforce report builder: Filtering data based on dynamic date ranges e.g. last 200 days or next 3 weeks and not just the following available options: **Note** # To appreciate... Continue Reading →

Complex Salesforce Reports: Compare ‘moving averages’ with ‘current month’ value

**Introduction** This one is another use of the almighty Custom summary formula (CSF) in Salesforce reports. Use them - they don't bite! **Note** To appreciate the solution, I hereby request all my readers to try to solve/create the report (described... Continue Reading →

Email scheduled reports only if not empty (and other advanced conditions) Part-2

The topic has 3 posts, of which this is called post 2 or part 2. 1. Part 1: This post covers sending email with a link to the report only if the total number of records are NOT zero i.e. not... Continue Reading →

Unlocking ‘Report and Dashboard’ sharing

The knowledge of reports and dashboard sharing is a must for all admins who want to show and enable the right reports for their users. Below you will find a table that I use as a guide to setup the sharing model... Continue Reading →

Rollup fields for lookup relationships

**Introduction**   One of the questions that is asked almost every 3rd Day (my random estimation) has a solution that lies in having roll-up fields for lookup relationships. There is an awesome app from Andrew Fawcett (at that you... Continue Reading →

Caution with CASE statements in a Salesforce formula

The bold statement: CASE formula always calculates all values (including else) even if a condition has already been met. Use case: Create a formula field to calculate the 1st day of next month from closedate (for simplification lets assume all months have... Continue Reading →

Spring 17 Reports & Dashboards Updates in Lightning Experience

Email scheduled reports only if not empty (and other advanced conditions) Part-1

**Introduction** A common user requirement and indeed a basic one is to send an email of a scheduled report to the users only if the report is NOT empty. To some extend this is now possible using the Salesforce standard... Continue Reading →

Protected: Possibly an issue: upload file with READ only access to object

There is no excerpt because this is a protected post.

Powered by

Up ↑