Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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"
END

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

Related questions

Browse Categories

...