Skip to main content

Advanced statistics

They determine the most probable and the most frequent values and builds frequency tables. The main advanced statistics include the following values:

  • Mode: computes the most probable value. For numerical data or continuous data, you can set bins in the parameters of this indicator. It is different from the "average" and the "median". It is good for addressing categorical attributes.
  • Value Frequency: computes the number of most frequent values for each distinct record.
  • All other Value Frequency indicators are available to aggregate date and numerical data (with respect to "date", "week", "month", "quarter", "year" and "bin").
  • Value Low Frequency: computes the number of less frequent records for each distinct record.
  • All other Value Low Frequency indicators are available to aggregate date and numerical data (with respect to "date", "week", "month", "quarter", "year" and "bin"), where "bin" is the aggregation of numerical data by intervals.

The following table shows the indicators that you can select in any database:

Indicator Supported data types with the Java analysis engine Supported data types with the SQL analysis engine
Mode
  • Number
  • Text
  • Date
  • Number
  • Text
  • Date
Value (Low) Frequency
  • Number
  • Text
  • Date
  • Number
  • Text
  • Date
Date (Low) Frequency
  • Date, with the exception of time
  • Date, with the exception of time
Week (Low) Frequency
  • Date, with the exception of time
  • Date, with the exception of time
Month (Low) Frequency
  • Date, with the exception of time
  • Date, with the exception of time
Quarter (Low) Frequency
  • Date, with the exception of time
  • Date, with the exception of time
Year (Low) Frequency
  • Date, with the exception of time
  • Date, with the exception of time
Bin (Low) Frequency
  • Number
  • Number

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!