Conditional formatting based on dynamic cell value

Question & Answer
,
1

Hello everyone :slight_smile:

we are trying to build a dynamic analysis but we can’t figure it out how to set a formula based on cell values rather than a set value. Take as example the first picture, each cell must have a colored arrow based on the corresponding cell on its left:

fields
fields1176×530 62.9 KB

Is it possible to insert a custom code or formula to build this logic?

Thanks

2

Hi,

Thank your for reaching out. To do this you will need to create calculated fields that perform the comparison. See this thread. The formulas will be dependent on the structure of the visual.
https://community.amazonquicksight.com/t/how-to-compare-the-numbers-in-each-columns-automatically-and-show-some-icons-before-the-numbers/1808

Best,
Sean