Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I replace the number after counting with the name of the Airline?
Replace the number? Not sure what you mean
Something like this:
It shows the country who ranks first in sum(Sales)
concat( distinct if( aggr(rank( total sum(Sales)) , countries_world.Name )=1, countries_world.Name))
or this...
concat( distinct {<countries_world.Name={"=aggr(rank( total sum(Sales)), countries_world.Name )=1"}>} countries_world.Name)