CASE WHEN in table calcs

[sam8]

Knowledge Drop

Last Tested: March 22, 2021

Though a case when in table calcs is currently a feature request (see https://feedback.us.pendo.io/app/#/case/32191), you can make it work with nested if statements. If you use coalesce, it becomes even more readable:

coalesce(
 if(${field} < 1, "Less than 1", null),
 if(${field} =< 2, "1 - 2", null),
 if(${field} =< 3, "2 - 3", null),
 if(${field} =< 4, "3 - 4", null),
 if(${field} =< 5, "4 - 5", null),
 "More than 5")

This content is subject to limited support.