Skip to main content

Naming Prefixes and Common Error Reference

Field naming pattern table, recommended prefixes, and the common error patterns and fixes table.

PatternExampleAnti-Pattern
Descriptive nounSales YTDCalculation1
Prefixed by type% Rev GrowthMy Calc
Abbreviated clearlyCust First OrdCustomerFirstOrderDateForCohort
Boolean as questionIs Repeat?RepeatCustomerFlag_v2_final
  • Σ or m_ — Measures
  • Δ or d_ — Dimension calcs
  • ◉ or f_ — Boolean/filter calcs
  • ₮ or tc_ — Table calcs
  • _ or z_ — Hidden helpers (sort to bottom)
Error (wording varies by Tableau version)Root CauseFix
Mixing aggregate and non-aggregate argumentsSUM([A]) + [B] where [B] not aggregatedWrap: SUM([A]) + MIN([B]) or use ATTR()
Aggregate calc used with a non-aggregated fieldDimension on measure-only shelfUse LOD or ATTR() wrapper
Circular reference between calcsCalc A → B → ABreak cycle: introduce third calc
NULL everywhereTable calc dimension not in viewAdd dimension or change Compute Using
LOD ignoring filterFIXED computed before dimension filtersAdd to Context, or use INCLUDE
Very large or slow LOD resultLOD creating huge intermediateAdd constraining dimensions
LOOKUP wrong valueAddressing direction wrongCheck Compute Using + sort order
% of Total = 100%TOTAL() scope same as numeratorAdjust addressing