Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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

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

29.3k questions

30.6k answers

501 comments

104k users

Browse Categories

...