How to plot dynamic values with different color

Dear community,

  • What Grafana version and what operating system are you using?
    10.0.10, Linux

  • What are you trying to achieve?
    I want to plot data as a statetimeline in different colors without hardcoding the value/color.
    For example i have a column “Order Number”. The Order-Number is generated randomly and i want to show it on a statetimeline. The Order-Numbers should be separated in different colors. For now i can’t use that without hardcode the values in “value-mappings”. I have a solution for TimescaleDB which is not that efficient. But i’d like to have a solution for MSSQL as well.
    The “Order-Number” is just an example and mostly the plotted values are strings.

Result Now:

Result i want to achieve: (In this image i use the Timescale-DB workaround).

  • How are you trying to achieve it?
    With “Group By” i achieved a workaround for Timescale-DB.
    SELECT

$__timeGroupAlias(“time”,$__interval),

“$Filter”,

CASE

WHEN “$Filter” = ‘sdf’ THEN 1

ELSE 1

END AS " "

FROM processdata

WHERE

$__timeFilter(“time”)

GROUP BY 1, “Anlage”,2

ORDER BY 1,2

I can’t use that workaround for MSSQL because i join over multiple tables.
I tried many different ways but i can’t find a solution.
Do anyone has an idea how to achieve that? Or knows a plugin?

thanks in advance

Regards,
Kari