Knowi Product Update Q3 2017

Stats, Stats Everywhere

Statistics Data Overview

The system now allows you to view the statistical metadata about your datasets such as the total number of rows and columns, max. and min. values, mean and standard deviation. The dataset overview can be viewed by selecting the bar chart icon on the Analyze Grid. For more detailed analysis, pairwise scatterplots of the interaction of each data variable with its peer are also available from the overview.

Learn More

Filter Like You Mean It

Generating filter values based upon a separate query
The system now supports filtering based on the results of another query. This dynamic filtering capability is achieved by first creating a query that returns possible filter values and then selecting the database icon next to add/remove filter buttons. Clicking this option will set the auto-suggestions based upon the secondary query results.

Setting the Filter Audience
The system now offers the options when setting filters at both the Dashboard and the Widget level. You can set a personal filter that is only seen by you. Admins and Dashboard owners can set a global filter which acts as a default filter for all users and admins can reset filters which resets any personal filters back to the global default set by the Admin or Owner

Multi-value user filter support
An admin can now add to a user's profile user specific filter parameters to be passed into queries upon user login

Being RESTful

REST-API Pagination Support

Added the ability to add paging to a REST-API datasource. The system will automatically loop through multiple pages to collect data when some tokens are defined.

Loop JOIN

The system now supports the concept of a Loop JOIN. This type of join allows you execute and retrieve the results for the first part of the join and for each row (from the resulting set) extract the template value, update the second query in the join, execute it then combine the result with the current row.

Other Cool Stuff

Adding Steps to the Ad-hoc Grid	After creating your query and previewing the data returned in the ad-hoc grid, the ability now exists to add multiple steps to the same data query workflow. Learn More

Grid Formatting	A new feature has been added that allows for alignment of data in the Data Grid widget type. The data grid also supports conditional formatting of colors based upon content value. Any formatting made to the data in the grid will be passed through into any subsequent PDF exports. Learn More

Automated Dashboard Sharing	There may be cases when any asset that the user creates needs be automatically shared to other groups. In such cases, you can apply an 'Automatic Share to Group' setting that will automatically publish any assets created by the user to those groups that can be used by other users. Learn More

New Datasources	Knowi has added native integration with Snowflake, a cloud-based SQL data warehouse. Learn More

New Visualizations	Threshold This visualization allows for the simple tracking of your key metrics. A user can: Select the metric to monitor Enter a threshold value Choose the display color for when the metric is <= the threshold Choose the display color for when the metric is > the threshold Data Summary Display the data in summary form. (Ex. Total messages delivered, opened, etc.)