Convert Boolean ✅❌

Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Convert Boolean [Category: Conversion]

This function converts a binary or Boolean values (i.e. true/false, pass/fail, 1/0) to a graphical emoji icon (✅ or ❌) to aid visual presentation in the UI.

See below for a preview of the function definition along with some outputs for different input values:

Using Data Studio's bulk apply method for transforming many columns at a time, this handy function will help add a pop of colour to the grid of data to help you easily see the good and bad in your results however they are presented.

Feel free to adjust this function to use other emoticons, here is a handy link to help you see the art of the possible:


This function is compatible with all instances of Data Studio from v2.1.11 onwards.