Use String Values in Formulas in the Compare Table Column Editor

Create formulas with string values without using the SAQL editor. Now you can write simple statements directly in the Explorer’s compare table formula editor. Use string values to create labels, concatenate dimension values, provide simple buckets, or add image URLs.

Where: This change applies to Einstein Analytics in Lightning Experience and Salesforce Classic. Einstein Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

How: Edit a column and enter your string formula. In this example, the formula creates simple buckets.

Column editor showing a formula that creates three simple buckets

This formula concatenates two dimension fields.

Column editor showing a concatenation formula

The Lit Meter column in this table has a string formula that returns a number of icons.
Compare table showing images in a column
Tip

Tip

Columns based on string formulas can’t be used as dimensions for grouping in charts, but they can be used to apply conditional formatting in charts.