No Join function support in Grafana?

[tcasanova]

@fercasjr

from(bucket: “SmartGraph Sensor Platform”) //Everythin is pulled from the same bucket
|> range(start: -3h)
|> filter(fn: (r) => r[“ValueType”] == “Avg” or r[“ValueType”] == “AlarmHyst” or  r[“ValueType”] == “AlarmMax” or  r[“ValueType”] == “AlarmMin”) //use or to select multiple "Tags" on the same query
|> group(columns: [“SensorID”], mode:"by") // group by sensorID, this way all will by grouped by SensorID
|> pivot(rowKey:["_time"], columnKey: ["ValueType"], valueColumn: "_value") //Use Pivot to have one column per previous result on the data tables streams
|> filter(fn: (r) => r[“AlarmHyst”] == 10 ) //use the filters that you need.
|> filter(fn: (r) => exists r[“AlarmMax”]) //if there is a chance you have null values use this
|> filter(fn: (r) => exists r[“AlarmMin”] ) //if there is a chance you have null values use this
|> filter(fn: (r) => exists r[“Avg”])           //if there is a chance you have null values use this
|> experimental.unpivot()    //unpivot will convert each column in its own data stream (_field. _value, _time)
|> yield(name: "custom-name") //display results

this works out of the box, nice one without knowing the data structure

While I was tinkering I got it to work using the pivot function as well but the problem is with the pivot function i lose all the extra tags which I use as alerttemplates in the summary etc…

My initial query from the first post though… If i run it in InfluxDB UI I cannot see what’s wrong with the output data… if I drop _field and _value a whole lot of tables get generated with different tag combinations… I’m thinking I must be missing something very simple and it should work…