Feature request: Graphing multiple timeseries

[arthurh4]

Very awesome plugin !

I'm trying to graph the following query:

SELECT my_date_field as Time , status, COUNT(*) as Value FROM my_table where LAST_LOAD_TIME>'$__timeFrom(yyyy-MM-dd)' GROUP BY 1,2 LIMIT 100

This returns the following:

Time                | status| Value
2020-07-07 11:34:20 | up    |    1
2020-07-07 11:34:20 | down  |    2

This table cannot be used directly in Graph panel however if we could turn the status column value into a column name using something like a pivot the graph panel would work. I tested in pure SQL and it works but its very annoying to write.

I was wondering if we could use the Transform Labels to fields but to do that we need to be able to add labels the dataframe ?

Is it possible to implement a feature to label the "Value" column using other non "Time" columns ?