On Monday, September 26, 2016 at 7:54:25 PM UTC+5:30, Robert wrote: > I'm not sure of the best way to help with your first question, but my answer > to your second may answer your first. > > For question 2, you'll want to set up a template variable on the dashboard as > described here: http://docs.grafana.org/reference/templating/ with your "SHOW > TAG VALUES WITH KEY = "host" query. > > The grafana demo site has some examples here: > http://play.grafana.org/dashboard/db/influxdb-templated-queries?editview=templating > > Once you have the variable set up your query would look like this (assuming a > template variable of "hostname"): "SELECT mean("usage_system") FROM "cpu" > WHERE "host" = /^$hostname$/ AND $timeFilter GROUP BY time($interval) > fill(null)". The query builder should also include the template variables in > any where clause you include for easier replication. The template variable > will also populate the variable's dropdown list with all values, which might > solve your first question. > > On Monday, September 26, 2016 at 6:43:06 AM UTC-4, [email protected] > wrote:Hi Team, > I am creating dashboards in Grafana using InfluxDB as datasource. I am new to > InfluxDB and Grafana. I started creating dashboard and has below questions. > Question 1 > I am using the below query to get the list of hosts in table panel of > Grafana. > There are two output columns are displayed. One with column name "Time" and > with text "Invalid date" is displayed below this column. The second column > name is "value" and host names are displayed below this column. > Query used - SHOW TAG VALUES WITH KEY = "host" > Why "Time" column is coming and how to remove this column. I need only the > list of host names. > Question 2 > I am displaying the CPU usage in graph panel of Grafana in same dashboard. > The host name is now hard coded in the query as below > SELECT mean("usage_system") FROM "cpu" WHERE "host" = 'esclient003' AND > $timeFilter GROUP BY time($interval) fill(null) > How to pass the host names as variable from first table panel which is > getting list of hosts. Which ever host is selected I need that host CPU Usage. > Please can any help me in this. > Thanks and Regards, > Sree
Hi Robert, I am able to do as you have suggested and got answers for both the questions. Thank you very much for support. Thanks and Regards, Sree -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/da0e4356-8d14-4fea-a6b8-ab490848c294%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
