Summary statistics - Cloud - 8.0

Talend Studio User Guide

Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Talend Studio
Design and Development
Last publication date
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

They perform statistical analyses on numeric data, including the computation of location measures such as the median and the average, the computation of statistical dispersions such as the inter quartile range and the range.

  • Mean: computes the average of the records.
  • Median: computes the value separating the higher half of a sample, a population, or a probability distribution from the lower half.
  • Inter quartile range: computes the difference between the third and first quartiles.
  • Lower quartile (First quartile): computes the first quartile of data, that is the lowest 25% of data.
  • Upper quartile (Third quartile): computes the third quartile of data, that is the highest 25% of data.
  • Range: computes the difference between the maximum and minimum values.

When using the summary statistics indicators to profile a DB2 database, analysis results could be slightly different between Java and SQL engines. This is because indicators are computed differently depending on the database type, and also Talend uses special functions when working with Java.

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
Mean Number Number
Median Number Number
Inter Quartile Range Number Number
Upper Quartile Number Number
  • Number
  • Date
  • Number
  • Date
  • Number
  • Date
  • Number
  • Date
  • Number
  • Date
  • Number
  • Date