I want to apply conditional formatting based on the box_category field: if the value is “Large”, it should be red; if it’s “Small”, it should be blue. However, when I try to do this in Amazon Quick Sight using the conditional formatting option and select box_category, it forces me to use an aggregation. I need the formatting to be based on the absolute (non-aggregated) value. Could someone please help me understand how to achieve this?
Hi @borahgb
Welcome to the Quick Sight community!
You can apply conditional formatting on fields like box_category by setting the aggregation to ‘No aggregation’, and applying red for Large and blue for Small. Refer to the image for your reference.
Hi @borahgb
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @borahgb
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!