Dynamic Coloring for Stock Price Movement

  • What Grafana version and what operating system are you using?
    Grafana v11.0.3 (7f69866eea)

  • What are you trying to achieve?
    Trying to dynamically display stock price color depending on whether it is higher or the same (green) or lower (red), based on current and last price.

  • How are you trying to achieve it?
    Various ways including pulling change info from dB, tried thresholds, changed queries

  • What happened?
    Most often get “No Data” in Stat card, and inability to change color

  • What did you expect to happen?
    Expect that when the price is shown and it is less than the most recent previous price, the current price is shown in red.

  • Can you copy/paste the configuration(s) that you are having problems with?
    I have played around with queries so much, not sure what works anymore! I am looking for basic principles to help me fix this…best type of visualization, how to parse information with dynamic formatting etc.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No Errors

  • Did you follow any online instructions? If so, what is the URL?