How can I prepend a positive number with a plus symbol?

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

Grafana v8.5.9 on Windows Server 2016

  • What are you trying to achieve?

On a dashboard designed to give me an overview of our support tickets, I have a counter that shows the difference between the new and closed tickets. This counter is shown using a single stat panel and is either a negative or a positive number. The entire dashboard is fed using SQL queries.

When the number is above zero I want to prepend it with a plus symbol.

  • How are you trying to achieve it?

I’ve tried using a custom unit that prefixes a ‘+’ but this plus also shows when the number is below zero. I also looked up value mapping but couldn’t figure out a way to make the display text include the actual value - and I’m not sure if that’s even supported in the first place.

I also tried just returning a string value from the query, by prepending a plus string in the query itself when the value is above zero, but for some reason this plus doesn’t show up at all when visualized. (though it worked fine in SQL Management Studio)

Thanks in advance!