Displaying Default or Custom Icons in the Grid Widget for the Null Values

You may want to display a default or custom icon in a grid widget when there is a null value. This can be achieved by using conditional formatting and expressions. Follow these steps to set up this functionality:

• Create an expression: Use the following condition to create an expression: `IF(ISNULL([Column_Name])='true', 1, 0)`. This expression checks if the `[Value]` field is null. If null, it returns 1; otherwise, it returns 0.
• Configure the grid widget: Bind the field you want to visualize in the grid widget.
• Open the conditional formatting dialog: Access the Grid widget properties and open the conditional formatting dialog.
• Select the Expression field: In the conditional formatting dialog, choose the Expression field in the "Based on" drop-down.
• Set the aggregation type:

  Select "Max" in the "Summary Type" drop-down for the Expression field

  .
• Apply the condition and save changes: After applying the condition, save the changes.

            

Now, the grid widget will display default or custom icons (such as a dash) for null values.