Jump to content

Recommended Posts

Posted

Hi,

I am new to Spotfire and trying to make some headway with the custom expression fields to bin a histogram for a Axis which is selected by a column property drop down. Spotfire seems to allow autobinning if an axis is not set from a property, but this nice feature goes away when it is fed from a property :(

As the autobin option is gone, I want to use FD selection criteria for the number of bins, by putting this into a custom expression* using the Autobinnumeric() function, I was building this up from a simple expression with a fixed number of bins which worked to then trying to calculate this criteria which threw an error.See examples of custom expressions below:

1)AutoBinNumeric($esc(${CQASelect}),10)

=> Worked without issue to bin historgram

2)AutoBinNumeric( $esc(${CQASelect}),(Round( ( Max($esc(${CQASelect})) - Min($esc(${CQASelect})) ) / (2 * IQR($esc(${CQASelect})) * (count($esc(${CQASelect})) ^ (-1 / 3) ) ),0)))

=> Tried to implement FD selection, throws error: Invalid type for function call 'AutoBinNumeric' on line 1, charachter 1

I was thinking that I made a syntax error, so just tried to put in a very simple modification of the above function for the second argument to see if this would work, but this threw the same error:

3)AutoBinNumeric( $esc(${CQASelect}),(Round(10,0)) )

Is it possible to add formulas as arguments as attempted above. Any help on this, or the problem of binning histograms made from properties would be much appreciated,

Many Thanks,

Rory

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...