Functions

Discussion List

• Sharing of useful functions to support contact data validation

  Hi all, I've found myself using a few functions on a regular basis so thought I'd share t…

  255 views 3 comments 3 points Most recent by Juha Ritvas October 2020General
• Function to calculate the number of working days between two dates

  Recently I wanted to create a function in Data Studio to calculate the number of working days betwe…

  2.3K views 1 comment 3 points Most recent by Simms, Henry June 2020General
• How to systematically sample with a fixed sample size and varying population size

  I was recently asked how to build a Data Studio workflow that would output a systematically sampled…

  321 views 2 comments 2 points Most recent by Simms, Henry May 2020General
• Extracting a specific piece of information from an address using regular expressions and lookups

  Data Studio has several built-in functions to allow you parse strings of text and extract a particu…

  2K views 2 comments 2 points Most recent by Simms, Henry October 2019General
• Getting started with Regular Expressions in Data Studio

  A regular expression (from here on we’ll call them “regex” for short) is a well-known and powerful …

  664 views 3 comments 8 points Most recent by Simms, Henry September 2019General