Count By Bands
Divides a specified range of values into a specified number of bands and counts the number of rows in a specified data table column that contain a value that lies within each band.
Usage notes
If Return Cumulative Percents is set to 0, this function returns a table containing one column that holds the midpoint values of each band (one row for each band), as well as one column containing the counts.
If Return Cumulative Percents is set to 1, the returned columns will contain the cumulative percentage of the total count in each cell, rather than the individual counts.
Arguments
The function has the following arguments:
Table: Data table column.
Number of Bands: Numerical value that specifies the number of bands into which to divide the specified range.
Include Min/Max: Numerical value (
0 for false and
1 for true) that determines whether the range of values is specified by
Min Value and
Max Value, or by the values in
Table.
Min Value: Numerical value that, together with
Max Value, specifies the range of values that is divided into the bands, if
Include Min/Max is
1.
Max Value: Numerical value that, together with
Min Value, specifies the range of values that is divided into the bands, if
Include Min/Max is
1.
Return Cumulative Percent: Numerical value (
0 or
1) that determines whether counts or cumulative percentages are returned. If set to
1, he function returns the cumulative percentage of the total count in each cell, rather than the individual counts.
This function returns a table.
Copyright © 2013
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.