Gradient color issue

[RFK]

Hello !

Here's a spotfire graph in which I'm trying to apply a color gradient.

However, I wanted to do it according to a Min and a Max that depend on a variable and not on the MinMax value of the graph.

To do this, I have a formula: Sum([BES_AGT].[BESOIN_AGENT]) but when i go to Columns : Settings i can only do a custom expression based on Axis.Color

So if the agent NEED is 14, I'd like the Max to be +14 and the Min -14, with the 0 in white. In this way, I can quantify the severity of over- or understaffing.

How can I do this?

[Olivier Keugue Tadaa]

Hi RFK

which version of Spotfire are you using? 
In my version 14.3.0, it is possible to add a custom expression on any column from your data table (see below)

[RFK]

I want to put the min as a negative value but it's pretty impossible

 

For exemple in this screen the Max should be +7 and the Min : -7. Because it's the exact same value.

[Olivier Keugue Tadaa]

can this work in your case?  ::: -Max([Axis.Color])