New Visualization - Red/Green/Yellow

Some data is best just glanceable - is it ok or not?
All green - let’s go to lunch, all red - panic mode.

In short, widget changes background color according to value above/below preset threshold.

Settings:

  1. Which value to observe.
  2. Define value thresholds and colors.
  • At least one threshold.
  • No limit on number of thresholds.
  • Each threshold can define color (preset color palette + picker)
  1. Widget content
  • Title
  • Show value on/off
  • Show time counter (since when threshold crossed) - NTH on/off

An example I took off google search

4 Likes

Should this be a new visualization type or just extra features for the counter visualization?

I think Counter won’t cover all widget potential uses which aren’t of linear numeric value.
For instance, server up/down (green - true, red - false), or server status code (green - 200, red - 500/404).

1 Like

How would you name this new visualization?

Status Monitor? Status Panel? Status Tracker?

1 Like

How would you name this new visualization?

“Super-Counter” (and also rename previous one to “Counter (Deprecated)”) :grinning:

3 Likes

Just an idea. For thresholds, current Counter expects “larger is better”. New visualization should be flexible enough to accommodate other cases such as “smaller is better” and “closer to zero the better”.

1 Like

Hi @ranbena

I could see a hack using Table visualization and Bootstrap divs (with styles bg-success, bg-danger, bg-warning). The only problem would be the table header and that’s why I’ve asked for a setting here.

Bye,

Arnaldo

Can you show me an example on the Deploy preview?

Please forgive my poor SQL (I wrote it as fast as I could):

https://redash-preview.netlify.com/queries/223#406

hello,

can we do this kind of visualization with several names and a color degradation

hello,
can you show us the sql code please

Hello,

can we have a demo for these type of vizualisation please