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 > > -- 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/d9f52a92-bc7a-4875-af0a-21789fe5ccd4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
