Stat Panel that shows text based on different inputs?

Hopefully my title made sense!

I am making a power dashboard, and I am stuck on something. I have a tile there which is a stat panel and I want it to show current power input. Its the one that says “100% Solar” in the screenshot

I’d like this to switch between the following possible options

  • 100% Solar
  • Solar + Grid
  • Grid Only
  • Portable Generator
  • Standy Generator

The 100% Solar and Solar + Grid are easy, as I just have value mappings to display that text based on if I’m exporting power to the grid or not

But, getting the rest are pretty tough. I can’t figure out how to do it. I have inputs that show the wattage of each items, and I have the logic worked out

  • IF “Main” is a negative value, then display “100% Solar” and be Green in Color
  • IF “Main” is a Positive Value and “Solar” is over 50w, show “Grid + Solar” and be Yellow In Color
  • IF “Main” is a Positive Value and “Solar” is less than 50w, show “Grid Only” and be Red in Color
  • IF “Main” is under 50w and “Portable” is over 50w, show “Portable Generator” and be Purple In Color
  • IF “Main” is under 50w and “Generac” is over 50w, show “Standby Generator” and be Orange In Color

Does it sound possible to do this? I am using InfluxQL, but if I need to use Flux to get it done, I will

I think it IS possible using Regex in the Value Mappings…

…but I know very little about how to write IF / AND / ELSE expressions, but am sure others do. Try Googling around and starting with something basic to get it to work.

Interesting, thanks for the information. If I can get a single Regex figured out for one of them, I’m sure I could do the rest