RFK Posted July 12 Share Posted July 12 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? Link to comment Share on other sites More sharing options...
Olivier Keugue Tadaa Posted July 12 Share Posted July 12 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) Link to comment Share on other sites More sharing options...
RFK Posted July 12 Author Share Posted July 12 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. Link to comment Share on other sites More sharing options...
Olivier Keugue Tadaa Posted July 12 Share Posted July 12 can this work in your case? ::: -Max([Axis.Color]) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now