Updated Oct, 17 2017 Updated
Stats, Stats Everywhere
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.
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
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.
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.
|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.
|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.
|New Datasources||Knowi has added native integration with Snowflake, a cloud-based SQL data warehouse.
This visualization allows for the simple tracking of your key metrics. A user can:
Display the data in summary form. (Ex. Total messages delivered, opened, etc.)
Please sign in to leave a comment.