Salesforce Date Formula Business Days

Salesforce Date Formula Business Day

A company needs to calculate the delivery date of an order. The standard delivery time is 5 business days (excluding weekends). If an order is placed on Wednesday, Salesforce should automatically calculate and show the delivery date as the following Wednesday (skipping Saturday and Sunday). In this article, we learn about how to calculate business … Read more >>>

Repeat Row Labels in Tableau

Display Repeated Row Headers in Tableau

When I was working on a Tableau report, I had the row labels grouped instead of being repeated for every row. With this, it was difficult to read the table because users had to view each row to understand which row label applied to it. For example, instead of seeing the row header repeated on … Read more >>>

Alias Notations in Salesforce SOQL

Use Alias Name in SOQL Relationship Queries

In Salesforce, while working with SOQL queries, we need to write the queries correctly to retrieve the data and make it understandable to the user. In Salesforce, we have the feature of “aliasing” names; for example, the user name John Smith will appear as jsmith in the alias name. We can also use the alias … Read more >>>

Query to Count Child Records in Salesforce SOQL

Salesforce SOQL COUNT function in subqueries

In Salesforce, relationships between objects can be defined as either master-detail or lookup relationships, and using SOQL, we can query the details of the child records, such as the record count of child records. In this Salesforce tutorial, I will explain how to query and count child records in Salesforce SOQL. SOQL Queries for Child … Read more >>>

HAVING Clause in SOQL (Salesforce Object Query Language)

Use WHERE Clause With HAVING Clause in SOQL Query

In Salesforce Object Query Language (SOQL), when we want to apply any condition in the query, we use the WHERE clause, and we can apply logic there. The HAVING clause is also used to apply conditions in the query, but we can use the HAVING clause in SOQL when we filter results that aggregate functions … Read more >>>

How to Create a Table in Tableau

Create Highlight table in Tableau

Recently, I was creating a sales report using Tableau. In this report, I needed a simple way to compare Sales, Profit, and Quantity across different product categories. Using a bar chart, it was possible to show the trends, but I would like to display the data with the dimension name and measure values, similar to … Read more >>>

Agentforce Employee Agent and Service Agent in Salesforce

Agentforce Employee Agent and Service Agent in Salesforce

While working with agents in Salesforce, there are various types of agents with distinct capabilities. We can only deploy some of them in the Salesforce org so that Salesforce users can use them, while others can be deployed on external sites, such as community sites, for external or end users. In this Salesforce tutorial, we … Read more >>>

Salesforce SOQL Query RecordType

Count number of records assigned to record type in Salesforce SOQL

In Salesforce, RecordTypes allow us to group records of the same type for an object. It will enable the customization of page layouts, fields, required fields, and picklist values for different user profiles, as well as restrict field access for layouts and the creation of records.  For example, you can create record types to ensure … Read more >>>