Use Second Column from Infux Query

1

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!

2

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.