How to Display Work Items Not Updated in the Last 7 Days in Bold BI

In Bold BI, you can create a widget that displays all work items that have not been updated in the last 7 days. This can be achieved by creating a new computed column in the data source using an expression, and then filtering this column in the widget configuration.

Creating a New Computed Column

To create a new computed column, you need to write an expression in the data source. The expression should be set to return ‘true’ if the work item has not been updated in the last 7 days, and ‘false’ otherwise. The expression should look like this:

case when [Status]!='Closed' and DATEDIFF(day, [System.ChangedDate],now()) >= 7 then true else false end

For more information on how to configure expression columns, refer to the BoldBI documentation.

Filtering the Widget

Once you have created the computed column, you can filter it in the widget configuration. To do this, set the filter to show only the work items for which the computed column has the value ‘true’. This will display only the work items that have not been updated in the last 7 days.

For more information on how to set filters at the widget level, refer to the Bold BI documentation.

Note: The term “work items” refers to any data points or records in your data source that you want to track or monitor and the datediff function is supported in the following data sources in Bold BI:

1. SQL Server
2. MySQL
3. PostgreSQL
4. Oracle
5. SQLite
6. Amazon Redshift
7. Azure SQL
8. Google Cloud SQL
9. Snowflake.

Conclusion

By creating a computed column and filtering it in the widget configuration, you can easily display all work items that have not been updated in the last 7 days in Bold BI.

References

1. Configuring Expression Columns - BoldBI
2. Working with Widgets: Manual Filters - BoldBI