You could do that automatically from the query, add a case function that adds a column with that info and then in the customizations just pick the column that has the color. Also could use transformations or even a conditional field override. But it feels like the most straightforward could be from the query. -Leandro