Skip to main content

Einstein Analytic Notes: Binding

Binding type: selection and result.
Selection: a user need to click on somewhere in the dashboard. Selection interaction can be used to:
  • Specify interactions between widgets which use queries from different datasets.
  • In addition to filters, specify the measures, groupings, and other aspects of a query.
  • Set widget display properties for some widget types (number and chart only
Result: user does not need to click on dashboard or there is hidden step. A results interaction is typically used to:
  • Define intermediate results for a complex calculation. For example, to calculate the total opportunity amount for the top-five products, use one query to calculate the top-five products. Then use those results to filter another query that calculates the total number of open cases for each product.
  • Set an initial filter selection for a dashboard based on a characteristic of the logged-in user, like their country.
  • Dynamically change the display of a widget based on the results of a query. For example, you can configure a number widget to show different colors based on the value of the measure. (In dashboard designer only.)

Data Selection Functions
  • cell Function: Returns a single cell of data as a scalar (single value), like "This salesperson rocks", 2, or null. An error occurs if the rowIndex is not an integer, the columnName is not a string, or the cell doesn’t exist in the table.
Syntax: cell(source, rowIndex, columnName)
  • column Function: Returns one column of data (as a one-dimensional array) or multiple columns of data (as a two-dimensional array).
Syntax: column(source, [columnNames...])
  • row Function: Returns one row of data (as a one-dimensional array) or multiple rows (as a two-dimensional array). For selection interactions, you typically use this function to return the first row or all rows. For results interactions, you might want specific rows. To determine the row index, display the query results in a values table.
Syntax: row(source), [rowIndices...], [columnNames...])

Note:
escape the string by using \”\”.
column() should be use with .asObject() and 
cell() should go with .asString()

Resources:

Comments

Post a Comment

Popular posts from this blog

The flow failed to access the value because it hasn't been set or assigned error

I'm sure that many Salesforce admin already encountered the this Process builder error when building automation referencing a field on a related record (aka lookup field): ' The flow failed to access the value because it hasn't been set or assigned ' and came across this Salesforce document . However, it does not help in case of referencing a User lookup field. ------------------------------- Use case: when a lead's ownership is transferred to another user, respective fields are updated based on their profile.  Error element myDecision (FlowDecision). The flow failed to access the value for myVariable_current.Owner:User.ProfileId because it hasn't been set or assigned. --------------------------- Workaround:  Have a condition to check if the record is assigned to a user or a queue before checking their profile id for respective actions. Records owned by user: BEGINS([Lead].OwnerId, "005") Records owned by queue: BEGINS([Lead].Owne...
Post a Comment
Read more

Salesforce campaign model and tracking

  Salesforce campaign tracking   Check out the great article on Campaign tracking use case: https://www.salesforce.com/blog/track-salesforce-campaign-shadow-wolf-blog/   There are 2 ways to track Campaign ROI .    Campaign Influence ( custom model )   Associate multiple Campaigns to multiple Opportunities (and multiple Opportunities to a Campaign) using the Contact Role . To get a broader view of opportunity pipeline, generate the standard report called Campaigns with Influenced Opportunities (Customizable Campaign Influence). This report provides opportunity data, such as amount, stage, and revenue share alongside helpful campaign details.      For more control, build custom reports that show relationships such as these examples.   • Campaigns with Influenced Opportunities   • Contacts with Campaign Influence   • Accounts with Campaign Influence     If there is only one campaign associated with each opportunity ...
Post a Comment
Read more

Renewable vs Evergreen Subscription type

Renewal: Renewable products transfer to renewal quotes.  Standard renewable contracts have end dates, terms, and an option to renew. Evergreen: don't have any end dates and, therefore, don't need to be renewed. This supports an open-ended term of service that allows for customers or providers to cancel or terminate the subscription at any point.  Evergreen and Renewable products can’t coexist in a bundle. Guidelines for Evergreen Subscriptions:   https://help.salesforce.com/s/articleView?id=sf.cpq_evergreen_limitations.htm&type=5 Quote and Manage Evergreen Subscriptions:  https://help.salesforce.com/s/articleView?id=sf.cpq_evergreen_use.htm&type=5
Post a Comment
Read more