Probably a simple question, but I can’t figure out if and how to do it?
I want to format a field, but in a dependency to another field. Is that possible? For example:
If field A has the value 1, field B should be red if >10, green if <10. If field A has the value 2 then field B should be green at >20 and green at <20.
Ticket NR | SLA | Reaction Time
0815 | 1 | 9 (GREEN colour)
8457 | 1 | 11 (RED colour)
8427 | 2 | 12 (GREEN colour)
Is that possible?
You can either highlight A or the whole row.
I already know this, but unfortunately it does not help me with my question. My problem is that I want to set the selected color in relation to another field. Is that possible?
Like I said - you have 2 options, neither of which you want.
Thanks for your help, but sorry, i don’t unterstand.
Is something like this possible?
You’d have to highlight the entire row.
Ok, if I take the whole line, then I can refer to several fields for choosing the color? That would be also perfect!
@jom It sounds like you’re looking for this feature request:
https://github.com/metabase/metabase/issues/11125 - upvote by clicking on the first post
In the meanwhile you could incorporate in your SQL code the logic by using a third column, and show there as Text RED, GREEN. And do a conditional on the third column.