Tableau: How do I create categories from a dimension based on the count of another dimension?

Question

I had a spreadsheet that consists of flight delay data and I want to show the total delay time per airport. I want to create categories of airports divided into small, medium, and large

There is an IN/OUT filter with a  set "Small Airports", which is created on dimensions"Airports" based upon the formula

COUNT([Flight Number])<500

 

Answer 1

Try by using the following formula

IF COUNT([Flight Number]) < 500 THEN "Small"
ELSEIF COUNT([Flight Number]) < 1000 THEN "Medium"
ELSE "Large"
END

If you want to learn more about it Tableau, then go through this Tableau Training for more insights.