Version: #3588
New:
-
Aggregation Filter & HAVING Clause Support: Cloud9QL now supports the HAVING clause, allowing users to filter on aggregated values in queries.
- A new Aggregation Filter section has been added to Analyze, enabling drag-and-drop filtering on aggregated metrics directly in the UI.
- NLP integration is also supported—questions like “Identify the campaigns that achieved over 200,000 conversions” will now correctly apply aggregation filters to return grouped results.
Video
-
AI – Ask questions (NLP) Improvements:
- Introduced Custom AI Instructions in the Search-Based Analytics settings, allowing dataset-level rules to be included upon NLP prompts for more tailored responses.
- Added support for applying filters on nested JSON structures, enabling more precise queries on deeply nested fields.
- Fixed an issue where "Equal To" was incorrectly interpreted as "Less Than or Equal To" in certain NLP queries.
- Trino as a supported Datasource: Knowi now supports Trino as a native datasource connection. Users can connect to Trino clusters to run queries and visualize data directly within the platform.
Other:
- When sharing assets, the user selection dropdown now displays both the username and full name (formatted as username (name)) instead of just the username. This makes it easier to identify and select the correct users, especially in organizations with similar usernames.
- Added a new autoScroll option to the Knowi JavaScript API, defaulting to true. This allows developers to disable automatic scrolling to the embedded Knowi view when rendering on a page. Set autoScroll: false to prevent page jump behavior and maintain custom scroll positioning.