We are excited to announce our June 2019 Bold BI product update. This release brings several enhancements and new features to Bold BI widgets and data sources. These major changes and improvements provide you the best experience with Bold BI dashboards.
Here are the new updates:
- Choropleth and Bubble maps now support United States counties.
Data source updates
- Support for Excel tables with Microsoft Excel Open XML Format Spreadsheet file (.xlsx) format.
- Support for ServiceNow built-in template.
- Support for DateDiff expression and WITH query support.
US maps support in choropleth and bubble maps
We have added support for showing United States counties in our choropleth and bubble map widgets. The following figure is a sample dashboard that shows the population by county of Alabama, New York, Washington, and Montana.
Previously, we had support only for continents, a worldwide map showing all countries, and a few maps of individual countries. Now we have added maps of all states and their counties in the US.
Data source updates
Table support in Excel data sources with .xlsx format
With Excel data sources, you can now import an entire spreadsheet or only selected tables into Bold BI. Once imported, you can explore the information and prepare dashboards to see the story that lives in your data.
Previously, we had support only for importing an entire spreadsheet. Now, we support connecting Excel tables in Microsoft Excel Open XML Format Spreadsheet file (.xlsx) format.
ServiceNow built-in template support
We have added support for the ServiceNow Web API in our built-in dashboard templates for quickly creating dashboards. You can connect your own ServiceNow data by updating your credentials and easily build a dashboard in just a few clicks.
The following image is a sample template dashboard that uses ServiceNow. The dashboard is used to monitor incident details over a period of time. It provides accurate information regarding average resolution time for an incident and the status of incidents based on category and priority.
DateDiff expression and WITH query support
The DateDiff function has been included to return the difference between two specified dates. The following screenshot shows the Expression Designer supporting the DateDiff function.
WITH clause in query
The WITH clause in custom SQL code provides a way to write auxiliary statements for use in a larger query. These statements, which are often referred to as common table expressions or CTEs, can be thought of as defining temporary tables that exist just for one query.
The following screenshot shows the data source designer supporting the WITH clause in the code view.
Excited to try these features?
If you have any questions or require clarifications, please use the comments section available below. You can also contact us by submitting your queries here, or if you already have an account, log in to submit your support query. We are happy to assist you. Give it a try and let us know what you think!