Conditional Color in Bars Graph

Hello, good morning.

Its possible to change the bar color based in the record input?

Example:

If Records > 100

Color = Red

Elif Records <= 100

Color = Yellow

Elif Records <= 50

Color = Green

Hello @Mauro_Campos

Welcome to the Community!!

In metric view we have this kind of color specific conditions which can be applied.

If you still need this in bar diagram then we will have to use layering , please find below details related to same :

Example :

Sample formulas from above link.…you need to review as per your bar chart :

Red => average(bytes) * clamp(floor(average(bytes) / 15000), 0, 1)
Green => average(bytes) * clamp(floor(average(bytes) / 10000), 0, 1) - average(bytes) * clamp(floor(average(bytes) / 15000), 0, 1)
Blue => average(bytes) * clamp(floor(average(bytes) / 5000), 0, 1) - average(bytes) * clamp(floor(average(bytes) / 10000), 0, 1)

Thanks!!

1 Like