Display the time as a range in the widget
In Bold BI, you can display time as a range in widgets using conditional expressions. This can be achieved by defining a range using an expression and applying it to the widgets.
Steps to Display Time as a Range:
1. Create a conditional expression to define the range. Here's a sample expression:
IF(HOUR([startdate]) = 0, '00:00 - 01:00',IF(HOUR([startdate]) = 1, '01:00 - 02:00',IF(HOUR([startdate]) = 2, '02:00 - 03:00',IF(HOUR([startdate]) = 3, '03:00 - 04:00', IF(HOUR([startdate]) = 4, '04:00 - 05:00', IF(HOUR([startdate]) = 5, '05:00 - 06:00', IF(HOUR([startdate]) = 6, '06:00 - 07:00', IF(HOUR([startdate]) = 7, '07:00 - 08:00', IF(HOUR([startdate]) = 8, '08:00 - 09:00', IF(HOUR([startdate]) = 9, '09:00 - 10:00', 'RangeUndefined'))))))))))
2. Apply the expression to the widget.
3. The widget will now display the time as a range based on the defined expression.
Note: This is applicable to all the data sources in Bold BI.
Related Articles
