This content has been marked as final. Show 2 replies
I have a dataset that shows trips taken from a city to another city. I've created a path map and using size, show which trip is more popular by making the line bigger. However, what I'd like to do is highlight the top 3 trips. I cannot get the Rank function to work. I've attached a packaged workbook. In the example: I've set Pittsburgh as the primary city and the trips coming out of Pittsburgh. This is how the ranking should work. But when I use the rank function in the Path map, it does not work (because Lat/Long is changing how it ranks). How can I get around this? Thank you for your help!