Calculating and Grouping Generations / Age Stratification in Domo

Tatyana_K

Hi all - I figured since I got Domo Support's help on calculating generations / age stratigification I would share the beast mode calculation for anyone else that would find this useful and not have to reinvent the wheel.

 

CASE
WHEN `dateOfBirth` >= '1946-01-01' AND `dateOfBirth` <= '1964-12-31' THEN 'Baby Boomer'
WHEN `dateOfBirth` >= '1965-01-01' AND `dateOfBirth` <= '1981-12-31' THEN 'Generation X'
WHEN `dateOfBirth` >= '1982-01-01' AND `dateOfBirth` <= '1996-12-31' THEN 'Millennials'
END

 

Cheers,

TK

Tatyana_K

Sharing solution