Use Second Column from Infux Query

My apologies in advance if this is a dumb question! Just fighting with it, can’t seem to figure it out … :frowning_face:

I have an output from an Influx query, trying to use it to set a variable,

name: rate
time top host

1546349588000000000 3137032 chromecast
1546349666000000000 10717008 phone
1546349667000000000 3711432 googleHub
1546349781000000000 12577840 roku
1546349800000000000 31388552 myPC

I want to sort on the second column, but use the last column as the variable (i.e. selector for my plot). Is this possible?

Thanks for your help!

OK, to save others the same grief (if needed) … got it working. Need to run a SELECT on a SELECT -> get just the host values.