What are custom fields?

Custom Fields provide you more flexibility over your data requirements by giving you a new tool for data cleaning, manipulation, and calculations. You may now add a new, customizable field, at the record-level, to your raw data stream and save it for later use. Now, a saved custom field can be created at a stream level and used across multiple workspaces.


Who can use custom fields?

This feature is available for all admin and power users on the new Stratifyd UI.


When should I use custom fields?

You can use custom fields whenever you need to add new fields to your data set. Here’s a few use cases that can be addressed with Custom Fields:

  • Adding internal custom metrics at a document-level to leverage raw source data

    • Example: Custom “Proprietary Impact Score”

  • Adding custom grouping (without needing bins)

    • Example: Converting a “group_id” of numbers to the name of the group

    • If group_id==12039130 then ‘Marketing’ else ‘Other'

  • Cleaning up number formatting

    • Example: cleaning up null values by setting as 0

  • Create a word count of your unstructured data fields

  • Converting categorical data to numerical data


How do I use custom fields?

  1. From your Stratifyd Workspace, navigate to the data stream in which you’d like to add a new field.

  2. Select the Data Fields tab.


  3. Click the Add Field button.

  4. Add an expression and rename the field.

    TIP: See a full list of supported functions below.

  5. Validate and check your sample results

  6. Click the Submit button to save the field to your data stream

    This custom field is now available in your data stream.

What functions are supported?

STRING FUNCTIONS

NUMBER FUNCTIONS

DATE

FUNCTIONS

LOGICAL FUNCTIONS

CONTAINS

ABS

DATEADD

CASE

ENDSWITH

CEILING

DATEDIFF

END

FIND

DIVIDE

DATENAME

IF

FINDNTH

EXP

DATEPART

IFNULL

LEFT

FLOOR

DATETRUNC

IIF

LEN

MIN

DAY

ISDATE

LOWER

POWER

ISDATE

ISNULL

LTRIM

ROUND

MAKEDATE

MAX

SIGN

MAKEDATETIME

MID

SQRT

MAKETIME

MIN

SQUARE

MONTH

REPLACE

NOW

RIGHT

TODAY

RTRIM

YEAR

SPACE

HOUR

SPLIT

TRIM

UPPER

WORDCOUNT


Editing Fields in a Data Stream

You may wish to control which data fields are included in your analysis. There is a limit of 300 data fields per stream, so if you are leveraging multiple sources in a single stream you may need to review which should be included. Here's how to do so:

  1. From your Stratifyd Workspace, navigate to the data stream in which you’d like to add a new field.

  2. Select the Data Fields tab.

  3. Click Edit Fields.

  4. Use the check boxes to manually select or deselect individual fields you'd like to add or remove. You can also use the box at the top to select or deselect all fields at once.

  5. Once you've selected the fields you'd like to include in your analysis, click Reprocess Stream.

Additional Resources

Release Notes

Further questions?

We're here to help! Don't hesitate to contact us for further assistance via chat or submit a ticket!

Did this answer your question?