Jump to content
We've recently updated our Privacy Statement, available here. ×

Perform normalization in line charts with line-by function with respect to a particular value in X-Axis.


Sudhansu Mishra

Recommended Posts

Hi all,

I'm trying to normalize the line chart with respect to a particular Y-value corresponding to one predefined value of X-axis. Could someone indicate how to go ahead and do this in Spotfire. I've reviewed some links like https://www.tibco.com/blog/2017/02/06/how-to-normalize-or-standardize-yo... but they don't describe how to normalize as per my requirement.

For eg. I'd like to normalize each line with respect to their corresponding Y-value when X=6000.0

Link to comment
Share on other sites

Thanks @jim_w. Two questions

 

1. if [x]=6000, ,[y],0 . Does this mean that if x is not equal to 6000, a value of 0 is returned else the value of Y at x=6000 is returned  If this is the case, then the division will return an infinite value for all the X values except 6000.

 

2. I'm interested in the true value instead of Sum. Is it possible to use Value instead of Sum or any reason why Sum is used. 

 

Reason is when I used the connotation /statement provided, I didnot get any output and the error is The expression is not valid. 

Link to comment
Share on other sites

1. No - the 'sum over all' means the values of

If([x]=6000,[y],0)

are summed for all values of [X]. As these will be zero for all values that do not equal 6000, and [Y] at 6000, the value returned will be [Y] at [X]=6000.

2. I used Sum because an aggregation method is required in the chart when dividing a function by an OVER function.

I've attached a DXP with an example of this.

Link to comment
Share on other sites

1. if [x]=6000, ,[y],0 returns zero apart from when [X]=6000.  These values are then summed OVER ALL([X]) - so the result for all values of [X] is the value of [Y] when [X]=6000.

 

2. Sum([Y]) is needed because an aggregated value is required for the chart.  As long as your values of [X] are unique it should not be an issue.  If you use calculated columns rather than a custom calc in the chart, you do not need the Sum().

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...