How to 3 decimal in colour field (gradient, fixed...)

[Diego Herrero]

Hello everyone!

I am adding colours to my bar charts (%values). I want to put the following rules:

0,997

[Kirsten Smith (she/her)]

Go into Column Properties/Formatting and increase the decimals used for the coloring column

[Diego Herrero]

Hi,

Sorry, I didn't explain properly. Although I set that option to 3 decimals, the colour filter does not allow me to use 3. It automatically round the value.

I hope the images help to understand my problem.

Thank you!

[Diego Herrero]

Read my new comment. Ty!

[Kirsten Smith (she/her)]

I just confirmed that if the Column Properties is set to 3 decimal places you can enter three decimals in the Color ranges. See attached screen shots.

[Diego Herrero]

I did exactly the same and didn't work. I tried again today and didn't work.

 

And a problem related to the configuration of Spotfire Is there any option that automatically round the values

 

Thank you!

[Diego Herrero]

Ok, solved!

 

The option 'custom expression'  accept 3+ decimals. With the other options i wasn't capable of doing it, althought i had 3 decimals in the calculated column.

 

Thank you!