Welcome to the community, Chris! :grinning_face_with_big_eyes: The image/link restriction is likely because you’re early in your forum use. If you do a lot more here, the system will automatically remove those restrictions.
In your [Trends] table, add a rollup field named {Ages}, drawing from the links in the {People} field, and pulling in their age, using the following aggregation function: ARRAYJOIN(values, “”). For the first row, this will give you something looking roughly like this: BoomerMillenialMillenialSilent (the order may be different).
Next, add a formula field named {Boomer Count} (or just {Boomers} if you prefer), containing the following formula:
LEN(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
Ages & "",
"Boomer",
"X"
),
"Millenial",
""
),
"Gen X",
""
),
"Gen Y",
""
),
"Silent",
""
)
)
In short, this will replace all instances of “Boomer” with an X, remove the rest, then get the length of the result, which will be the count of Boomers matching that trend. (Note: this assumes that your screenshot showed all possible age options. If not, add more nested SUBSTITUTE functions as needed.)
Duplicate this field, then change the formula so that one of the other age names is replaced by Xs, and Boomer is removed. Name that field to match the one being counted. Lather, rinse, and repeat until you have each age counted in its own field.
