Demystifying Field Types in Sugar Discover

Fields in Discover have a field type that denotes what kind of data is held in each field. These field types are signified by icons directly preceding the field name.

Let's look at each icon and give an explanation as well as some common examples of each.

Icon Field Type Description Example Fields
 String String fields hold text and alphanumeric values. In Sugar Discover, fields that have this type often get their values directly from your CRM instance. They may hold data like names of people, accounts, and opportunities. Account Name, Sales Stage, Assigned User
 Calculated String Calculated strings hold text and alphanumeric values, though they differ from standard string fields because they get their values as a result of a calculation that takes place within Discover. These calculations return text and alphanumeric values such as parsing the day of the week from a date, or the ID of a record. Day of Week, Forecast Category, Records
 Number Number fields hold numeric values. These values are often in the form of currency such as the likely value of an opportunity. These fields and their calculated counterparts are often used in the Metrics shelf to track values in reports. Likely, Best, Worst
 Calculated Number Calculated number fields hold numeric values. Calculated number fields differ from standard number fields because they get their number value as the result of a calculation that takes place within Discover. A prominent example is "AVG Deal Size," which takes the "likely" amount from your closed-won opportunities and provides the average amount of revenue gained between them. AVG Deal Size, Age, Record Count
 Timestamp Timestamp fields hold date values such as "Date Modified" and "Date Created". These fields can be added to the X-axis of a report, or as a filter to show historical changes in data. Timestamp fields can be further refined by their child fields: "Year," "Quarter," "Month," "Day," or simply display the entire date. Snapshot Date, Date Created, Expected Close Date
 Boolean Boolean fields hold a value that represents a binary state or condition. In other words, the conditions represent a choice between two options: true or false, on or off, active or inactive, 1 or 0. Discover often leverages these fields to classify report results. For instance, the boolean field "Closed Won," represents a binary choice; either your opportunity is in a closed-won state or it is not. Closed Won, Increased, New

Do you want to discuss this tip with other SugarClub members? Do you have your own tips to share? Ask a question or start a conversation in the SugarClub Help Forums!