Title: Datameer Functions  
Owner: Charles Bishop
Creator: Charles Bishop Jan 30, 2018
Last Changed by: Charles Bishop Feb 04, 2019
Tiny Link: (useful for email) https://datameer.atlassian.net/wiki/x/A4ozcQc
Export As: Word · PDF  
Datameer v7 (9)
    Page: Available Plug-ins
    Page: Data Field Types in Datameer
    Page: Filtering Data Using Formulas
    Page: Glossary
    Home page: Home
    Page: US Presidential Candidates
    Page: Using Operators
    Page: Working With Date and Time Information
    Page: Working with Workbooks
Hierarchy
Children (21)
    Page: Alphabetical List of Supported Datameer Functions
    Page: Using the Formula Builder
    Page: Using Operators
    Page: Using Regular Expressions
    Page: Convert Data Field Types with Functions
    Page: Comparison Functions
    Page: Date and Time Functions
    Page: Encoding Functions
    Page: File Functions
    Page: General Functions
Labels
There are no labels assigned to this page.
Time Editor  
Feb 04, 2019 16:37 Charles Bishop View Changes
Sept 11, 2018 07:38 Charles Bishop View Changes
Jan 30, 2018 15:50 Charles Bishop  
Outgoing Links
Datameer v7 (291)     Page: GROUPROWNUMBER
    Page: ADDTODATE
    Page: CONCAT
    Page: URL_ENCODE
    Page: Comparison Functions
    Page: FLOAT
    Page: MILLISECOND
    Page: Encoding Functions
    Page: GROUPANY
    Page: INTERSECTION
    Page: E
    Page: GEOHASH_ENC
    Page: List Functions
    Page: STARTSWITH
    Page: GROUPOR
    Page: FACT
    Page: T
    Page: ABS
    Page: Logical Functions
    Page: GROUPPERCENTILE
    Page: REVERSE
    Page: GROUPAND
    Page: GROUPCOMBIN
    Page: LTRIM
    Page: TOJSON
    Page: JSON_VALUE
    Page: PRODUCT
    Page: GAMMADIST
    Page: GROUPAVERAGE
    Page: TIMESTAMPDIFF
    Page: ANALYZE_POLARITY
    Page: SUM
    Page: CONTENTS_BY_TAG_NAME
    Page: QUOTIENT
    Page: SINH
    Page: Trigonometry Functions
    Page: GROUPCOUNTDISTINCT
    Page: MIN
    Page: GROUPSESSIONS
    Page: Text Mining Functions
    Page: XMLVALUE
    Page: INDEX
    Page: LIST
    Page: URL_HOST
    Page: EXP
    Page: RANGE
    Page: MONTH
    Page: Data Field Types in Datameer
    Page: CEILING
    Page: REMOVEALL
    Page: ENDOFMONTH
    Page: EXTRACT_NOUN
    Page: CONVERT
    Page: ASINH
    Page: URL_AUTHORITY
    Page: LISTELEMENT
    Page: ENC_BASE64
    Page: MSTODATE
    Page: DEC_BASE64
    Page: URL_FILE
    Page: EXTRACT_ORGANIZATION
    Page: SUBSTITUTEALL
    Page: MATCHES
    Page: TODAY
    Page: WEEKOFYEAR
    Page: GROUPCONCATDISTINCT
    Page: OR
    Page: EXTRACT_WORDS
    Page: DEGREES
    Page: LEN
    Page: WEIBULLDIST
    Page: FLOOR
    Page: General Functions
    Page: ISNULL
    Page: PI
    Page: ASIN
    Page: Using the Formula Builder
    Page: RSHIFT
    Page: CONTAINS_IC
    Page: HOUR
    Page: ROUND
    Page: XMLVALUES
    Page: RADIANS
    Page: Text Functions
    Page: URL_REF
    Page: RTRIM
    Page: COMBIND
    Page: RANDBETWEEN
    Page: GROUPTOPN
    Page: ATAN2
    Page: CODE
    Page: TRUNC
    Page: CRON_MATCHER
    Page: GROUPMIN
    Page: JSON_KEYS
    Page: GEOHASH_DEC_LAT
    Page: LEFT
    Page: SIZE
    Page: DAYOFYEAR
    Page: GROUPSUM
    Page: DIFF
    Page: NOT
    Page: GROUPSTDEVP
    Page: GROUPSTDEVS
    Page: NOW
    Page: XML Functions
    Page: SIN
    Page: QUARTER
    Page: SUBSTR
    Page: ISEVEN
    Page: CEILINGDATE
    Page: RAND
    Page: TRIM
    Page: ADD
    Page: GROUPANOVA
    Page: COMPRESS
    Page: TIMESTAMP
    Page: LOG10
    Page: REPLACE
    Page: SELECT
    Page: UNIQUES
    Page: RANDGAUSSIAN
    Page: ENDSWITH
    Page: JSON_MAP
    Page: PROPER
    Page: GROUPTTEST
    Page: REMOVE
    Page: GROUPUNIQUES
    Page: JSONTOLIST
    Page: ATANH
    Page: FORMATDATE
    Page: ExcelConverter
    Page: YEAR
    Page: REMOVE_ELEMENTS_BY_TAG_NAME
    Page: GROUP_SORT_ASC
    Page: GROUPBOTTOMN
    Page: GROUPBYCUSTOMBIN
    Page: BITAND
    Page: URL Functions
    Page: DIV
    Page: ELEMENTS_BY_SELECTOR_QUERY
    Page: TOKENIZELIST
    Page: MAX
    Page: JSON_ELEMENT
    Page: EXTRACT_PERSON
    Page: ASDATE
    Page: EXPONDIST
    Page: ROUNDDOWN
    Page: REPT
    Page: MROUND
    Page: ISBLANK
    Page: FACTD
    Page: COPY
    Page: NGRAM
    Page: STEM_WORDS
    Page: URL_TLD
    Page: LOG
    Page: ROUNDTIME
    Page: IF
    Page: EQUALS
    Page: Date and Time Functions
    Page: INDEXOF
    Page: URL_PROTOCOL
    Page: RIGHT
    Page: ACOS
    Page: Using Operators
    Page: CHISQDIST
    Page: EXTRACT_ADJECTIVE
    Page: COMPARE
    Page: COMBIN
    Page: HTML Functions
    Page: PLUS
    Page: REMOVE_HTML_TAGS
    Page: TDIST
    Page: SUBLIST
    Page: REPLACEALL
    Page: ATAN
    Page: REGEXTRACT
    Page: REGEX
    Page: URL_DEFAULT_PORT
    Page: LOGNORMDIST
    Page: GROUP_PREVIOUS
    Page: PROPERTY_VALUE_BY_TAG_NAME
    Page: SORT
    Page: BEFORE
    Page: Statistical Functions
    Page: SUBSTITUTEFIRST
    Page: COALESCE
    Page: ISODD
    Page: GROUP_SORT_DESC
    Page: GROUPCONCAT
    Page: NGRAM_OLD
    Page: ODD
    Page: GROUP_PAIR
    Page: TEXT2HEX
    Page: COSH
    Page: GE
    Page: NOT_EQUALS
    Page: GCD
    Page: EXTRACT_SMILEYS
    Page: ROUNDUP
    Page: SIGN
    Page: SECOND
    Page: URL_PORT
    Page: MOD
    Page: FDIST
    Page: EXTRACT_VERB
    Page: BIGDECIMAL
    Page: LSHIFT
    Page: GROUPACCUMULATE
    Page: URSHIFT
    Page: GROUP_DIFF
    Page: GT
    Page: GEOHASH_DEC_LONG
    Page: SUBTRACT
    Page: WEEKDAY
    Page: CONTAINS
    Page: GROUPSELECT
    Page: TANH
    Page: GROUPJSONOBJECTMERGE
    Page: DEC2HEX
    Page: Grouping Functions
    Page: EXPLODE_RANGE
    Page: URL_QUERY
    Page: IP_TO_NUMBER
    Page: Date and Time Parse Patterns
    Page: GROUPFIRST
    Page: GROUPMAX
    Page: SQRTPI
    Page: EXPAND
    Page: INT
    Page: UPPER
    Page: NUMBER_TO_IP
    Page: BITOR
    Page: URL_PARAM
    Page: GROUPMAP
    Page: TOKENIZE
    Page: URL_PARAMS
    Page: GROUP_PATH
    Page: URL_USERINFO
    Page: GROUPBY
    Page: BIGINTEGER
    Page: AVERAGE
    Page: DENULLIFY
    Page: LCM
    Page: EXTRACT_LOCATION
    Page: AND
    Page: STARTOFWEEK
    Page: EVEN
    Page: CORRECT_SPELLING
    Page: GROUPBYBIN
    Page: ACOSH
    Page: LOWER
    Page: GROUPLAST
    Page: URL_PATH
    Page: LN
    Page: Math Functions
    Page: HEX2DEC
    Page: STDEVP
    Page: ISEMPTY
    Page: DAY
    Page: GROUPBYGAP
    Page: LT
    Page: FLOORDATE
    Page: MIDNIGHT
    Page: SQRT
    Page: JSON_ELEMENTS
    Page: STDEVS
    Page: TAN
    Page: MINUTE
    Page: GROUPMEDIAN
    Page: EXTRACT_MONEY
    Page: ELEMENTS_BY_TAG_NAME
    Page: REMOVE_STOP_WORDS
    Page: URL_PLD
    Page: NORMDIST
    Page: GROUP_JACCARD_DIST
    Page: COS
    Page: COT
    Page: GROUP_PATH_CHANGES
    Page: STARTOFMONTH
    Page: GROUPCOUNT
    Page: EXPAND_DATE_RANGE
    Page: URL_DECODE
    Page: GROUPPREDICTIVEWINDOWS
    Page: LE
    Page: EXTRACT_DATE
    Page: CHAR
    Page: AFTER
    Page: POWER
    Page: SHIFTTIMEZONE