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
            Data Types for Insights SQL

            You are here:

            1. Salesforce Help
            2. Docs
            3. Data 360

            Data Types for Insights SQL

            When you define a calculated or streaming insight with SQL in Data 360, use the supported data types for your measures and dimensions. Measures are the numerical values you aggregate; dimensions are the qualitative fields you group by.

            Required Editions

            Available in: All Editions supported by Data 360. See Data 360 edition availability.

            Measure Data Types

            A measure is a numerical value enhanced by an aggregation function in an insight. Use one of these data types when you add a measure to an insight.

            Data Type Notes
            Currency When you use aggregate currency values as a measure, you must convert them to a single currency using TRY_CONVERT_CURRENCY.
            Integer Whole number values with no decimal places. Use for counts or quantities that don't require fractional precision.
            ListOfFloats An ordered list of floating-point numbers. Use for vector or multi-value measures.
            Number Decimal (floating-point) values. Use for measures that require fractional precision.
            Percent Returns a number. For example, 50% + 1 = 51.

            Dimension Data Types

            A dimension is a qualitative field you use to categorize and group your measures. Use one of these data types when you add a dimension to an insight.

            Data Type Notes
            Boolean True or false values.
            Date Includes timestamp.
            DateOnly Excludes timestamp.
            Email Returns data in text format when the insight uses a transform node.
            Phone Returns data in text format when the insight uses a transform node.
            Text String (character) values.
            URL Returns data in text format when the insight uses a transform node.
             
            Loading
            Salesforce Help | Article