Knowledge Base - Sisense Community

JavaScript must be installed and enabled to use these boards.<p> Your browser appears to have JavaScript disabled or does not support JavaScript. Please refer to your browser's help file to determine how to enable JavaScript.

Knowledge Base

Featured article

Enable/disable field suggestions in the NLQ (Simple Ask) For the latest version of Sisense like L2024.x to have a field suggestion, you need to enable it. First of all, what is the field suggestion, as illustrated by the picture below, if you want to get the revenue not for all Brands, but just for the brand APPLES. You type "revenue for APPL" and get the field suggestion. ALT text: A screenshot of a user interface showing a dropdown menu labeled "Widget" with options such as "Duplicate," "Delete," "Export," and "Simply Ask (NLQ)." Arrows highlight "Simply Ask (NLQ)" and "Modify NLQ Model" options within the menu. On the right, a panel labeled "Filters" displays an option to "Include all" under the "Brand" section. To enable this feature, you can do it in 2 ways. 1. Via REST API Go to Admin - REST API - 1.0 - nlq Find - POST /nlq/nlqAdvancedMode ALT text: A screenshot of a user interface showing a dropdown menu labeled "Widget" with options such as "Duplicate," "Delete," "Export," and "Simply Ask (NLQ)." Arrows highlight "Simply Ask (NLQ)" and "Modify NLQ Model" options within the menu. On the right, a panel labeled "Filters" displays an option to "Include all" under the "Brand" section. Press the button Try it out and after this Execute button After this, go to the dashboard, you should republish it After this, you should see the suggestions. 2. Changing the NLQ Model Go to simply ask and click on ‘Modify NLQ Model’. Look for the column we want to set the index to true and save it. Go to the dashboard, you should republish it. After this, our field suggestion should work perfectly. Why do we republish the dashboard after the changes, please check the article - Simply Ask (NLQ) Not Showing New Fields After Enabling Update For the versions L2024.2.x go to Admin - System Management - Configuration - 5 clicks on the logo - Ai-Integration - SimplyAsk and disable option - Hide Table Names May the force be with you

Knowledge Base Articles

Sorted by:

Reading multiple excel files into Sisense data model

Reading multiple Excel files into Sisense data model Introduction: If you are migrating from Windows to a Sisense Linux-hosted solution, on the Sisense Windows machine you may use an SFTP client that moves Excel files placed in a remote server's fol...

Limiting Date Range Filters in Sisense Dashboards

Limiting Date Range Filters in Sisense Dashboards Use Case Overview Wide date ranges in Sisense dashboards can lead to performance issues, especially when using live models or querying large datasets. For live data models, large queries increase cost...

How to Calculate Absolute Sum

How to Calculate Absolute Sum We have a table with data and we are going to calculate the absolute SUM for [sum] column. We divide this into two parts. First of all, we SUM all positive values with the formula ([Total sum],[sum1]) Th...

How to export snapshot file from Grafana

In case when it is not possible to share dashboard via https://snapshot.raintank.io/ (for example due to security policies) next flow could be used to export JSON of dashboard with required data included:Open required dashboard and set the time rang...

Featured article

Enable/disable field suggestions in the NLQ (Simple Ask) For the latest version of Sisense like L2024.x to have a field suggestion, you need to enable it. First of all, what is the field suggestion, as illustrated by the picture below, if you want to get the revenue not for all Brands, but just for the brand APPLES. You type "revenue for APPL" and get the field suggestion. ALT text: A screenshot of a user interface showing a dropdown menu labeled "Widget" with options such as "Duplicate," "Delete," "Export," and "Simply Ask (NLQ)." Arrows highlight "Simply Ask (NLQ)" and "Modify NLQ Model" options within the menu. On the right, a panel labeled "Filters" displays an option to "Include all" under the "Brand" section. To enable this feature, you can do it in 2 ways. 1. Via REST API Go to Admin - REST API - 1.0 - nlq Find - POST /nlq/nlqAdvancedMode ALT text: A screenshot of a user interface showing a dropdown menu labeled "Widget" with options such as "Duplicate," "Delete," "Export," and "Simply Ask (NLQ)." Arrows highlight "Simply Ask (NLQ)" and "Modify NLQ Model" options within the menu. On the right, a panel labeled "Filters" displays an option to "Include all" under the "Brand" section. Press the button Try it out and after this Execute button After this, go to the dashboard, you should republish it After this, you should see the suggestions. 2. Changing the NLQ Model Go to simply ask and click on ‘Modify NLQ Model’. Look for the column we want to set the index to true and save it. Go to the dashboard, you should republish it. After this, our field suggestion should work perfectly. Why do we republish the dashboard after the changes, please check the article - Simply Ask (NLQ) Not Showing New Fields After Enabling Update For the versions L2024.2.x go to Admin - System Management - Configuration - 5 clicks on the logo - Ai-Integration - SimplyAsk and disable option - Hide Table Names May the force be with you

Sisense

Leadership

News & Press Coverage

Careers

Contact Us

Security & Trust Center

Privacy Policy

Login

Marketplace

Add Ons

Integrations

Data Pipelines

Developers

Build with Sisense

Docs & APIs

Dev Community

Playground

Github

Resources

Community

Support Portal

Request a Demo

Whitepapers

Webinars

Follow us

Copyright © 2024 Sisense Inc.
All rights reserved.

Legal

Privacy

Copyright © 2024 Khoros, LLC