Loading
Prepare for Email to Become the Default Login ExperienceRead More
CRM Analytics
Add the Input Widget to Formula Queries

Add the Input Widget to Formula Queries

Retrieving values from the input widget to use in a formula can be done through the UI. You can add the input widget as a column in a query or with SAQL. The input widget works as a data source by collecting user inputs for use in other parts of the dashboard.

Steps in this section show you how to add the input widget to a calculation through the UI. To learn more using the input widget with interactions, see Create Interactions with Clicks

Add the Input Widget to a Formula Query

Use the input widget to build a formula in a new or existing query.

  1. Add an input widget to your dashboard.
    Adding an input widget to the dashboard.
  2. Create a query or select an existing query for building your formula.
    Adding an input widget to the dashboard.
  3. Edit the query you’re using to build your formula result.
  4. Add a column to the query and select Input.
  5. Search and select an input query.
    Adding the input query to an existing query.
  6. Add another column and select Formula.
  7. Use the formula editor to create a calculation using values from the input query.
    Using the input query in a formula.

Add the Input Widget to a SAQL Query

Add the input widget to a new or existing query using SAQL.

  1. Add an input widget to your dashboard.
  2. Create a query or select an existing query for building your formula.
  3. Edit the query you’re using to build your formula, and click Query Mode.
  4. Position your cursor in the SAQL code where to add values from the input query, and click the Add Input link.
    Adding an input widget to a SAQL query
 
Loading
Salesforce Help | Article