Loading
About Salesforce Data 360
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Configure Calculated Field Settings

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Configure Calculated Field Settings

            Like all fields, calculated fields have a field type of dimension or measure. Depending on the field type, calculated fields have additional field settings or metadata to be configured, such as data role, aggregation type, or sentiment.

            Required Editions

            Available in: All Editions supported by Data 360. See Data 360 edition availability.
            User Permissions Needed
            To configure a setting:

            Permission set:

            • Data Cloud Architect

            AND

            Semantic Models object
            1. Open the New Calculated Field window or Edit Calculated Field window.
            2. From the New dropdown, select Calculated Field. Or, click on a calculated field in the left pane.
            3. For Field Type, select Dimension or Measure. Dimensions are qualitative. Measures are quantitative and have an aggregation.
            4. From the Data Type dropdown menu, select the type of data the calculated field represents.
              1. Valid data types are Number, Text, Date, DateTime, Boolean, Percentage, URL, Email, Phone Number, and Currency.
              2. When you define the formula, the output must match the data type of the calculated field. For example, if the data type is Boolean, the formula can't have a numeric output.
            5. Enter a unique name.
            6. (Optional) To define advanced settings, expand Advanced. What options appear depend on the field type and data type. Not all options are always available and at times values are view-only.
              1. Description: A description to help users or agents understand the purpose of the calculated field.
              2. API Name: Enter a unique API name. You can’t edit the API name after the field is created.
              3. Aggregation: Specifies the aggregation for measures. If the formula contains aggregations, this should be UserAgg. Valid options include: UserAgg, Sum, Average, Min, Max, Median, Count, CountDistinct, StdDev, StdDevP, Var, and VarP.
              4. Decimal Place: For measures. The default is 2, use the - and + buttons to adjust between 0-9 decimal places.
              5. Data Role: Discrete or continuous. Dimensions are usually discrete and measures are usually continuous. For date and datetime fields in particular, whether they are discrete or continuous has a large impact on their behavior.
              6. Sentiment: Indicates the sentiment of an upward trend. Valid options are: Up is Good, Up is Bad, Up is Neutral.
              7. Treat Null as Zero (checkbox): Selecting this checkbox means nulls are treated as zeros for operations.
              8. Field Visibility (toggle): Whether or not the field is visible in the left pane.
            7. (Optional) For filters, see Add Filters to a Calculated Field.
            8. For the formula section, see Write a Formula in a Calculated Field.
            9. Click Validate to check your calculated field.
              1. Verify that the field type, data type, and formula aren't in conflict. Not all combos make sense, such as a continuous Boolean.
            10. Click Save.
             
            Loading
            Salesforce Help | Article