Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

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


1 Answer

0 votes
by (22.5k points)
edited by

Try by using the following formula

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

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

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers


104k users

Browse Categories