How to change or customize null in Bold BI
Bold BI supports the option to change null values in Dashboard widgets. This feature can be achieved by creating an expression column to replace the nulls in Bold BI widgets.
Use Case
Task due date in project management is a case where you may fail to update the tasks’ due dates in your data. You can therefore apply this concept and create an expression column to update the tasks’ due dates for the null values shown in the below image.
Creating expression and configuring in the widget
Create the expression column with the customized values to replace the null values. Follow the steps below to achieve this.
- Click on the Add Expression tab under the Assign Data pane to navigate to the expression designer window.
- Create the expression with the syntax as shown below to replace the null values.
CASE
WHEN [due] IS NULL THEN '01/02/2023 '
ELSE [due]
END
3. Click Save to update the expression then close to navigate to the Assign data tab of widget.
4. Configure the created expression column on the widget as shown below.
5. Now null values are replaced with an expression column and showcasing all values in the widget.
NOTE: When it is not able to customize as an empty value for null in the datetime type, convert it as string type and change it to empty.
if you want to achieve a different date type format, you can change the date format using the sample expression query below
Expression Query
CASE
WHEN [ ColumnName ] IS NULL THEN ' '
ELSE FORMAT([ColumnName],’M/d/yyyy’)
END
Related links
