1 Reply Latest reply: May 20, 2011 7:36 AM by Matthew Crowther RSS

    Autogenerate values based on intervals

      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

        • Autogenerate values based on intervals
          Matthew Crowther

          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