Histogram (Hist) Syntax - Aster Analytics

Version 1.0

The bin definition options are:

• The function can determine the bin boundaries automatically, using one of two built-in algorithms.
• You can specify the bin boundaries.
• You can provide the minimum and maximum values for the histogram, and an optional bin size. If you specify a bin size is, all bins have that size; if not, bins might not be the same size.

  SELECT * FROM hist (
    ON (SELECT 1) PARTITION BY 1
    InputTable (input_table)
    OutputTable (output_table)
    { AutoBin ({ 'Sturges' | 'Scott' | number_of_bins }) |
  
      CustomBinTable (bin_table)
      CustomBinColumn ('breaks_col') |
  
      StartValue ('bin_start')
      BinSize ('bin_size')
      EndValue ('bin_end')
    }
    ValueColumn ('value_column')
    [ Inclusion ({ 'left' | 'right' }) ]
    [ GroupbyColumns('group_by_column') ]
  );