Count & Group String by values not by timestamp

[mtenrero]

I'm trying to group my metrics in three states RED, YELLOW & GREEN, them, are stored in InfluxDB as a string, the query is : SELECT "YYYY" FROM "XXXX" WHERE $timeFilter but the results are always the same, sorted by tiemestamp and not grouped by value like in the screenshots provided in the readme.

Desired representation:

Actual representation:

(Legend works correctly)

Is there any kind of bug or am I doing something wrong?

By the way, great job with the panel!

[Asgoret]

@mtenrero Hi! Can you help with SQL? I have string data in DB (OPEN\CLOSED) and if i switch "Format as..." to "Table" panel show request error without errors) And if i use "Time series" panel show null point or unknown...or show two panels. One for "open" and one for "closed".

[Bagunda]

I have too... Panel shows two lines. One for "ON"and one for "OFF"