Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

At the top of each column, you can see a data quality bar, which uses the following color coding to validate the column values against the selected column type.

Color barDescription
greenValues that are valid for the current data type of the column
redValues that are mismatched for the column data type
grayMissing or null values
Tip

Tip: Click any of the color bars to receive suggestions for transformations to add to your recipe.

...

The following functions measure counts of values within a column, optionally counted by group. 

ItemDescription
COUNT Function

D excerpt include
pageCOUNT Function
nopaneltrue

COUNTA Function

D excerpt include
pageCOUNTA Function
nopaneltrue

COUNTDISTINCT Function

D excerpt include
pageCOUNTDISTINCT Function
nopaneltrue

UNIQUE Function

D excerpt include
pageUNIQUE Function
nopaneltrue

Aggregation functions

ItemDescription
AVERAGE Function

D excerpt include
pageAVERAGE Function
nopaneltrue

See also:

SUM Function

D excerpt include
pageSUM Function
nopaneltrue

MIN Function

D excerpt include
pageMIN Function
nopaneltrue

MAX Function

D excerpt include
pageMAX Function
nopaneltrue

MODE Function

D excerpt include
pageMODE Function
nopaneltrue

MINDATE Function

D excerpt include
pageMINDATE Function
nopaneltrue

MAXDATE Function

D excerpt include
pageMAXDATE Function
nopaneltrue

MODEDATE Function

D excerpt include
pageMODEDATE Function
nopaneltrue

Statistical functions - single column

...

  • Some of these functions have variations that use the sample population method of computation.  
  • IF conditional functions can be used to compute statistical computations based on a condition.

General statistics

ItemDescription
VAR Function

D excerpt include
pageVAR Function
nopaneltrue

STDEV Function

D excerpt include
pageSTDEV Function
nopaneltrue

MEDIAN Function

D excerpt include
pageMEDIAN Function
nopaneltrue

QUARTILE Function

D excerpt include
pageQUARTILE Function
nopaneltrue

PERCENTILE Function

D excerpt include
pagePERCENTILE Function
nopaneltrue


ItemDescription
APPROXIMATEMEDIAN Function

D excerpt include
pageAPPROXIMATEMEDIAN Function
nopaneltrue

APPROXIMATEQUARTILE Function

D excerpt include
pageAPPROXIMATEQUARTILE Function
nopaneltrue

APPROXIMATEPERCENTILE Function

D excerpt include
pageAPPROXIMATEPERCENTILE Function
nopaneltrue

Statistical functions - multi-column

ItemDescription
COVAR Function

D excerpt include
pageCOVAR Function
nopaneltrue

CORREL Function

D excerpt include
pageCORREL Function
nopaneltrue

Data Quality in Job Details

...