Best Of

@chrissy Instead of using the "Limit Rows" feature in analyzer, add a filter to your card using the Row number field you created in your ETL to only include rows where the row number is less than or equal to 20

You should be able to do a calculated field such as

CASE when City like '%New York%' then 'New York'
when City like '%San Diego%' then 'San Diego'
when City like '%San Francisco%' then 'San Francisco'
when City like '%Boston%' then 'Boston'
when City like '%Topeka%' then 'Topeka'
end

or

CASE when INSTR(City,'New York')>0 then 'New York'
when INSTR(City,'San Diego')>0 then 'San Diego'
when INSTR(City,'Boston')>0 then 'Boston'
when INSTR(City,'San Francisco')>0 then 'San Francisco'
when INSTR(City,'Topeka')>0 then 'Topeka'
end

Then use the field in a bar chart