AnsweredAssumed Answered

How to save a sql query result in a dashboard designer parameter?

Question asked by ElioteArg on Apr 21, 2016
Latest reply on Jul 22, 2016 by alberto.h.r

I created a dashboard in which I show the interface utilization for a device by using a context selector with two dropdown lists: One for devices and the other one for interfaces (of the selected device). We have a large amount of customers that have only one device, so I prefer not to show them the Device selector, but the query I use to list the interfaces for the device has this condition:

where source like '${device}', which is the parameter name for the Device selector.

 

Is there a way to save a query result (in this case, it would be a select top 1, for instance) in a global/local parameter in the dashboard designer? Or is it a way to show a result in the selector by default?

Outcomes