New
- Custom Text/HTML widgets no longer require a dataset. (2750)
- You can now create text widgets and banners without specifying a dataset/query.
- Video: https://www.loom.com/share/e861e1300f894e5a947140cc24701671?sid=bd8f4c3f-8e84-48d5-9861-6e9e4e36b689
- Example:
<style>
body {
font-family: Verdana, sans-serif;
}
body {
font-size: 40px;
}
</style>
<center>Hello!</center>
- Added support for Databricks SQL as a datasource (2858)
- Documentation: https://www.knowi.com/docs/databricks-sql.html
- New Customer setting to select dashboard NLP default tab (Data vs Visualization) (2893)
- Currently, the result of a dashboard NLP search defaults to the Data tab. If you would like the visualization tab to be the new default, Admins can change this under Customer Settings.
- Instructions: User Settings → Customer Settings → Natural Language Processing Setting → NLP Visualization First Tab, and select ‘ENABLE'
- NOTE: You may need to clear your browser cache.
- Added CONV function to C9QL to format hex strings into a different radix (2906)
- Syntax: CONV(<field name>, <field radix>, <desired radix>)
- Example: SELECT CONV(BF3C, 16, 10) -> Result: 48956
- Documentation: https://docs.knowi.com/hc/en-us/articles/115006860148-String-Currency-Operators
- Added REST API Paging Response Type option: Response contains relative to host the url of next page
- Use when query output returns a response that is relative to the host url for pagination
- Example: Host URL: www.example.com, Query output returns: /page2, /page3… which needs to be appended to host URL for next page
Improvements
- Dashboard drill down sharing permissions altered (2896)
- It is no longer required to manually share child dashboards configured within parent dashboard drilldowns. When sharing a dashboard with a dashboard drilldown configured, the user is able to view the child dashboard without it being explicitly shared. The child dashboard will not show up on the user’s dashboard listing unless it has been explicitly shared.
- Data grid column width will not reset for columns with dynamic column names (2791)
- As long as the column with a dynamic column name is in the same column position on a data grid widget, the column width will not reset upon query or widget refresh.
- Video: https://www.loom.com/share/96cd81fdc62d46658a72037bde57d135?sid=2a51f998-ca68-44c2-b407-50ee4dfbcfbd
- Fields with currency set as the data type will now have aggregation operations displayed in the widget data transformation tab (Count, Sum, Min, Max…) (2901)
- For date range filters using an auto-suggestion from another dataset, the time component for each month has been removed from the Custom range option (2878)
- For Pivot widgets, you can now sort date fields by clicking on the widget column header. Previously, clicking on a date field column header on Pivot tables would have no response. (2703)
- NLP search bar casing is no longer automatically converted to lowercase- search query will retain the same casing (2907)
- InstantSights Top/Bottom values text overlap fixed- previously text would either overlap or continue off the page. (2869)
- Embedded dashboard widget filters are now scrollable. Previously certain embedded dashboard widget filters were missing scrollbar. (2856)
- When deleting a user and transferring their assets to another user, the user being deleted no longer appears on the list of users to transfer assets to. (2821)
Operations Dashboard Improvements
The objective with these improvements are to a) find unused assets b) monitor usage and c) track low performing charts and queries.
- The Operations dashboard is now split into two tabs: Usage & Performance.
- Any Dataset Name references now include a link to navigate to the dataset management page directly. (see Charts & Dashboards example below)
- New metrics:
- Dashboard Loads in the Last 30 days (helpful to identify dashboards not being used)
- Logins By User & Type (Normal user, SSO User, Logins via Management API)
- Chart Loads: Displays average load times, Number of times loaded on a monthly breakdown. Useful to identify slow loading charts and unused charts.
- Direct Query Executions: Performance of Direct Queries, Average execution times and Average output size on a Daily Basis
- Query Errors: Single view of all failed queries with the ability to drill into each record for more details.
- Chart Creations/Updates, Dashboard Creations/Updates, Query Creations/Updates: Lists all Charts, Dashboards, and Queries (respectively) with their creation date and last modified date
- Charts & Dashboards widget now includes a hyperlink to each query’s dataset management page. (2411)
- Instructions: Click on the hyperlink under the ‘Dataset Name’ column to access the dataset management page for each chart/query.
