I have created a SQLv2 sensor with 10 channels showing differing information from the database. What I'd like to do now is show the data from 1 or 2 of those channels on a map in separate objects.
When I add sensors to the map it picks the primary channel to display. I'd like to be able to change that to pick a different channel. I can see that I could show this is in a table or graph format but that shows all channels and not just the ones I'm interested in showing. I don't want to disable the channels because I'd still like to see the data via other means but just not on my map.
I could create additional sensors for the channels I'm interested in but this causes a two-fold problem in that it would create additional load on the database when the SQL is run (3 queries now rather than 1) and also it eats into my sensor allocation.
Is there a way of displaying the data from a specific channel or is the only way to create additional sensors?