Developing Apama Applications > Dashboard Function Reference > Tabular Functions > Count By Bands
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.