We will give aliases to our resulting values in order to display them in a nice way. Under Edit Link select the Device Name, value (Status / Temperature / Set Point), target type (direct: it sends everything it knows periodically / On value change: only when the value changes it will be sent) Note for target type: for Set Point and Status you will need to set direct, to populate the database with the first data points. I seem to have found a solution. Hey guys, I have some data coming out of Home Assistant and I am looking for some help to format a graph properly. All is working as expected. Using Grafana v4.5.2. Topics in this section will be frequently updated as we work on this feature. I looked around, but ended up creating my own Docker image based on this awesome Docker setup by Samuele Bistoletti, Sams’s does everything I need, but it comes installed with StatsD/Telegraf, and uses MySQL. When that happens, Grafana displays a suggestion on the visualization that you … Here’s what my data looks like: I would ike to use the value i the field “friendly_name_str” as the alias for each of the lines. Alias by: [tag_path]] At the top of the page it probably says “Last 6 hours”, click this to change to “Last 30 minutes” ... “field(value) ... Grafana provides an ideal visualisation solution as it encourages sharing, and allows you to import whatever dashboards have been developed by Use Galaxy. Here is the query, the “achar” field is used for the grouping: SELECT UNIX_TIMESTAMP(atimestamp) as time_sec, aint as value, achar as metric FROM testdata.mysql_types WHERE $__timeFilter(atimestamp) ORDER BY atimestamp ASC EDIT: You can hardcode values as well: If you enable the Legend on a specific Graph then the chosen “measurement” will be displayed per default. As result=1 for the passed test cases, our total number of passed test cases is equal to the sum of the result field values. I'm playing with Grafana 2.6.0 and Influxdb 0.10.0 and I've run into some problem aliasing fields properly when using aggregations. Currently, it is using the entity_id which is correct but is not human readble. So, what I needed was a way to group all the hosts value into a single plot line. I have graphs defined from Elasticsearch source with long field names such as private_data.systemMetrics.systemData.cpu.usage_user. I found a way to display a short alias but it is costly. (“the first list”) I prompt with a template variable, and then filter by this tag value. I have something putting multiple field values into a series called mem: > SHOW FIELD KEYS FROM mem; name: mem ----- … There's an issue open here. Which is Grafana.There’s a few ways to install Grafana, but because I’m using Home Assistant on my Synology NAS, I’m going to use Docker.. I would like to set alias for the cpu usage fields that will display only the field name suffixes, in above example, usage_user. (Graph -> Legend -> Options -> Show) But how I can change this, not to show the name of the measurement, instead to show the specific tag value, that is part of each SQL Metric ? The total number of the failed test cases is equal to the difference between the number of test cases and the number of passed test cases. Transformations sometimes result in data that cannot be graphed. I want to set up a custom Alias. Note: Transformations is a Grafana 7.0 beta feature. That can be achieved with the following query: The second part is the interface. I have a Grafana dashboard, with an InfluxDB data source. It's a shame that Grafana doesn't support sub-queries, so the query needs to be inserted manually with raw view. I have InfluxDB measurements with a tag populated with one of three distinct tag values: “Partner”, “Sandbox”, and “unknown”. The “metric” field is the same as the “ALIAS BY” in InfluxDB. But, my users are confused by the term “Partner”.