Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Is there a way to find the max,min values for a calculated field in a chart table and split it to intervals into equal proportions?
eg my Interval is from -5 to 5, the interval would look like, -1 -2 -3 ...0...4 5.,
Any hel on this is appreciated, thanks in Advance
Just thinking off the top of my head but you could try looking at using either the class() function or the valueloop() function as your dimension - look in the help file for details on both.
The valueloop() expression could be something along the lines of:
=valueloop(min(Value),max(Value),1)
That is unchecked.
Hope that helps,
Matt - Visual Analytics Ltd