rashmi
March 5, 2021, 4:17am
2
I see that you are looking for conditional coloring in Canvas. There are few threads which discuss this in detail.See if it helps:
@Catherine_Liu I have basically the same problem not with the font color but with the background color
I have just one condition instead of two my approach is quite like the fist you gave to ksunil.
I do a select count(*) and if it is greater than 0 the backround should be green otherwise it should be red.
The expression editor looks like below
filters | essql query="SELECT * FROM uacuser WHERE logintime > NOW() - INTERVAL 1 MONTH AND disabled = 0" | math "size(userid)" | metric "Users logge…
and there is a GH issue as well
opened 06:46PM - 23 Apr 19 UTC
closed 03:44PM - 06 Apr 23 UTC
enhancement
Team:Presentation
design
loe:medium
impact:low
Feature:Canvas
**Describe the feature:**
As a Canvas users, I want to change the appearance of… an element based upon an underlying value. For example, set the metric font to red if a value under a specified threshold.
**Describe a specific use case for the feature:**
Whether I'm building a report or dashboard in Canvas, I may way want to emphasize a negative state by putting more visual emphasis on an element. This could be useful when there are a high level of negative occurrences (errors, security findings, etc.); likewise for positive occurrences. This could also be used for positioning, size, etc.
You can currently do this through the expression editor like so:
```
demodata
| math "unique(country)"
| metric "Countries"
metricFont={font size=48 family="'Open Sans', Helvetica, Arial, sans-serif" color={if {gt 10} then=red else=black} align="center" lHeight=48}
```
It is a question that comes up regularly which is why adding it to the UI (side panel settings) would be a nice way make this feature more discoverable. At first, it may simply be enough UI to handle two states that equate to an `if then else` statement. In the initial version, this could be visually assembled with some simple text inputs.
I can provide mockups, if necessary, when this is ready to be worked on.
Hope it helps
cc @Catherine_Liu