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?
-
From your Stratifyd Workspace, navigate to the data stream in which you’d like to add a new field.
-
Select the Data Fields tab.
-
Click the Add Field button.
-
Add an expression and rename the field.
TIP: See a full list of supported functions below.
-
Validate and check your sample results
-
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:
-
From your Stratifyd Workspace, navigate to the data stream in which you’d like to add a new field.
-
Select the Data Fields tab.
-
Click Edit Fields.
-
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.
-
Once you've selected the fields you'd like to include in your analysis, click Reprocess Stream.
Additional Resources
Further questions?
We're here to help! Don't hesitate to contact us for further assistance via chat or submit a ticket!
Comments
0 comments
Please sign in to leave a comment.