How to Convert Number Attributes to Text in BoldBI Dashboard

In BoldBI dashboards, you may come across a situation where you need to convert a number in a number attribute to display text. For instance, you may have a ‘Status’ attribute that returns a set of numbers (1,2,3,4) and these numbers are displayed in the dashboard widget. However, you may want to display text instead of the numbers (Urgent, High, Medium, Low). This can be achieved using the Add Expression feature.

Steps to Convert Number Attributes to Text

1. Navigate to the Add Expression feature in your BoldBI dashboard.
2. Create an expression column with the following expression:

if([Status]=1, 'Urgent', if([Status]=2,'High',if([Status]=3,'Medium',if([Status]=4,'Low',null))))

This expression will convert the ‘Status’ attribute numbers into the corresponding text. For example, if the ‘Status’ attribute returns the number 1, it will be displayed as ‘Urgent’. Similarly, the numbers 2, 3, and 4 will be displayed as ‘High’, ‘Medium’, and ‘Low’ respectively.

Conclusion

The Add Expression feature in BoldBI dashboards is a powerful tool that allows you to manipulate and customize your data display. By using expressions, you can convert number attributes to text, making your dashboard more intuitive and user-friendly.

References

• BoldBI Dashboard Documentation
• BoldBI Expression Columns