Examples | Adaptive Histogram | Vantage Analytics Library - Examples - Vantage Analytics Library

Required Parameters Only

call td_analyze (
  'adaptivehistogram',
  'database = val_source;
   tablename = customer;
   columns = income;'
);

Two Columns with Different Numbers of Bins

call td_analyze (
  'adaptivehistogram',
  'database = val_source;
   tablename = customer;
   columns = income, age;
   bins = 5, 3;'
);

Output Table and Several Optional Parameters

Specifies an output table and the optional parameters spikethreshold, subdivisionthreshold, subdivisionmethod. A SELECT statement displays the output table, whose ORDER BY clause is critical to interpreting the resulting sub-bins correctly.

call td_analyze (
  'adaptivehistogram',
  'database = val_source;
   tablename = customer;
   columns = income;
   bins = 5;
   spikethreshold = 12;
   subdivisionthreshold = 24;
   subdivisionmethod = quantiles;
   where = cust_id > 0;
   outputdatabase = val_results;
   outputtablename = adaptive_example3;'
);

SELECT * FROM val_results.adaptive_example3 ORDER BY 1,2,3,5,4;