Mode release notes
Mode release notes

String and distribution functions in Calculated Fields




New calculated field functions make it easier to clean up your data and find insights in your data without going back into the SQL.

String functions, like SUBSTR(MID), PLUCK(SPLIT), LEFT, RIGHT, FIND and REPLACE and null handling functions, like ISNULL and IFNULL, make it easy for anyone who doesn't want to edit SQL to clean up and wrangle data to make it more understandable.

Distribution functions, like SKEWNESS, KURTOSIS, STDEVP, and VARP, help analysts understand the shape of the data they’re working with, and reveal deeper insights. For example, the two charts below visualize the same data, but the second image adds variance (VAR). Adding this calculated field reveals differences in distribution characteristics that are not visible in the first.

Screenshot 2023-02-06 at 11.13.24 AM.png

Screenshot 2023-02-06 at 11.10.55 AM.png

Check out our Help site for all available functions, as well as best practices for using calculated fields.