Release date - February 24, 2025
What's in this release:
- New Options for the Date Range Slicer
- Divide-by-Zero Calculation Error on Streaming to TV Page
- Optimized Last Synced Field for Datasets & Hiding the Last Synced Time Filter in Datasets Quick Filter
- Redesigned AI Flow Block
New Options for the Date Range Slicer
For the Date Range slicer, we have added the following new options:
- Week-to-Date (Mon - Current)
- Week-to-Date (Sun - Current)
- Week-to-Date (Sat - Current)
- Last Week (Mon - Sun)
- Last Week (Sun - Sat)
- Last Week (Sat - Fri)
The option you select in the Date Range slicer will be displayed in the dashboards, reports, and scheduled reports that reference it, as well as when streaming these dashboards or reports to the TV.
Related article
How to Create a Date Range Slicer
Divide-by-Zero Calculation Error on Streaming to TV Page
Not only in a widget, dashboard, report page, but also when streaming a dashboard or report to TV, the error message Calculation Error - An attempt was made to divide by zero in the SQL code will appear in the following two scenarios:
- When the calculation formula in a widget's calculation layer is division, but the divisor is zero
- When the calculation formula in the SQL code of the dataset used by the widget is division, but the divisor is zero
If you want to fix the divide-by-zero calculation error, refer to How to Fix the Divide-by-Zero Calculation Error.
Required permissions
Normal users may encounter this error, but only admins can edit the widget to solve the error.
Related article
How to Fix the Divide-by-Zero Calculation Error
Optimized Last Synced Field for Datasets & Hiding the Last Synced Time Filter in Datasets Quick Filter
Optimized Last Synced field for Datasets
- For the API datasets, the Last Synced field on the Datasets page displays the most recent sync time.
- When the Last Synced field shows NA, the most recent sync time has not been obtained yet.
- When the Last Synced field shows Set Data Source, the dataset has not been set with a data source.
- If you want to view the date and time of the most recent sync for the dataset, submit a request to our Support team.
- If you want to view the date and time of the most recent sync for the dataset, submit a request to our Support team.
- SQL datasets do not currently support displaying the most recent sync time function because they cannot set a data source.
Hiding the Last Synced Time filter
We have hidden the Last Synced Time filter in the Quick Filter of Datasets.
Related article
Redesigned AI Flow Block
The AI Flow bot block has been streamlined to improve usability for clients. The redesign includes the following modifications:
- The AI workflows dropdown list is renamed Flow to be executed: and displays the available AI workflows in the client's tenant instead of indicating the file path.
- Input data in all the fields are sent by default.
- The link Edit AI Flow in the Workspace offers a shortcut to the MSPbots AI platform where users can directly edit workflows on the fly.
Only users with the AI Trial role can edit the AI Flow bot block.
Related article