Use Raw Field Names in Query Formulas

When writing compare-table formulas, you can reference measure and group (dimension) columns by name. Referencing measure and group columns by name lets you write more intuitive and easily understandable formulas. Even better, the formula editor includes nifty function and formula pickers that save you time as you enter your SAQL formulas.

You can use certain SAQL aggregate functions that require raw field names for arguments directly in the formula editor. These functions include percentile_desc and percentile_cont. You can also use the date function daysBetween in the formula editor.

Note In a compare-table formula, when you reference columns by default column names or user-defined column aliases, you can’t use raw field names in that formula.

Note You can use the date functions year_last_day, quarter_last_day, week_last_day, quarter_days, day_in_week, and day_in_quarter in the SAQL editor. Click to access the SAQL editor.

See these examples for how to use SAQL functions with raw-field references in the formula editor. Also see the Analytics SAQL Developer Guide for more information on SAQL functions.

sum(Amount)/100
percentile_cont(0.95) within group (order by 'LoadTime' asc)
regr_slope(Amount,Closed_On_epoch)
daysBetween(toDate(last(ModifiedDate_epoch), “yyyy-MM-dd”), now())
coalesce(sum(Amount), 0)
len(first(Description))