Knowledge Base

Setting Date Filter Members to Specific Days of the Week in Sisense Programmatically

Setting Date Filter Members to Specific Days of the Week in Sisense Programmatically Sisense natively supports a wide range of date filter functionalities and formats. However, certain scenarios may call for unusual custom programmatic forms of da...

Screenshot 2024-11-21 at 11.11.13 AM.png

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense When working with Sisense dashboards, programmatically modifying filters upon dashboard load via dashboard scripts for a specific user or circu...

Using Native Javascript Date Calculations To Modify Sisense Date Filters

Using Native Javascript Date Calculations To Modify Sisense Date Filters Sisense natively supports various types of date filter functionalities. However, there are instances where a dynamically updating date filter is desired based on dynamically ch...

Screen Shot 2023-11-21 at 7.30.17 PM.png

Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot Tables

Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot Tables Sisense’s Simply Ask feature empowers users to create visualizations instantly by asking natural language questions, simplifying data exploration without needi...

Modifying Simply Ask Natural Language Query Generated Widgets with Scripting

Modifying Simply Ask Natural Language Query Generated Widgets with Scripting Sisense's Simply Ask feature empowers users to create visualizations instantly by asking natural language questions, simplifying data exploration without needing technical ...

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...

Programmatically Formatting Bar Chart Widget Value Labels in Sisense

Programmatically Formatting Bar Chart Widget Value Labels in SisenseThis article outlines ways to programmatically format Sisense Bar Chart Widget Value labels via widget scripts, covering methods to prevent label overlap and apply consistent styling...

UserReplaceTool - Automating Dashboard Ownership Transfers - Useful for Deleting User Accounts

Automating Dashboard Ownership Transfer in Sisense with UserReplaceTool Managing and deleting user accounts in Sisense can create manual processes when users leave an organization or change roles. A frequent issue is the reassignment of dashboar...

Screen Shot 2024-07-21 at 4.15.44 PM.png

Screen Shot 2024-07-21 at 4.15.10 PM.png

Using the InternalHttp Function Within Scripts and Plugins

Using the InternalHttp Function Within Scripts and Plugins The InternalHttp function is a Sisense function within the Sisense internal Prism object. The prism object and the InternalHttp function are present on all Sisense pages and can be used in sc...

Resolving Export Limitations in Sisense

Resolving Export Limitations in Sisense This article addresses the inability to export more than 50,000 rows from a table in CSV and PDF formats in Sisense. The issue arises when the widget displays over 50,000 rows, but the export only includes 50,...

Advanced Pivot Widget Scripting - Combining Custom JAQL and the Pivot 2.0 API

Advanced Pivot Widget Scripting - Combining Custom JAQL and the Pivot 2.0 API While the Pivot Table Widget Type is a highly customizable and flexible Sisense widget for representing data in tabular form, certain use cases may be best achieved through...

Screen Shot 2024-03-10 at 10.04.01 PM.png

Screen Shot 2024-03-10 at 10.03.36 PM.png

How to List Dashboards and Data Models a User Has Access To

How to List Dashboards and Data Models a User Has Access ToAs a Sisense administrator sometimes you want a quick way to get the list of data models and dashboards a user can access. There is no direct way to do this through the user interface and thr...

Expanding on Using Native Javascript Date Calculations To Modify Sisense Date Filters

Expanding on Using Native Javascript Date Calculations To Modify Sisense Date Filters Sisense offers native support for various types of date filter functionalities and also allows users to create and modify dynamic filters entirely using dashboard...

Screen Shot 2024-01-30 at 5.04.56 PM.png

Using the "desc" Description Parameter of a Sisense Dashboard via the REST API

Using the "desc" Description Parameter of a Sisense Dashboard via the REST API and the Dashboard Javascript Object The description parameter ("desc") of the Sisense dashboard object is notable for its somewhat unique characteristic – it's not access...

Screen Shot 2023-11-30 at 8.26.19 PM.png

Screen Shot 2023-11-29 at 7.52.53 PM.png

Planning, Executing, and Monitoring your Dashboard

Introduction The following article discusses a dashboard's (high-level) development cycle. It breaks the process into easy measurable steps that start from the initial KPI planning all the way to maintaining and adjusting your end product. Table of C...

How to install new kernel or update existing one in Ubuntu

Some OS related issues could be fixed by installing a different Linux Kernel. In this article we will review how to install a new kernel and make it bootable by default.Installing a new kernelDisplay version of currently running Kernel: uname -r Exam...

SSO Router Plugin Usage With Examples

SSO Router Plugin Usage With Examples SSO Router PlugIn Overview: The SSO Router plugin allows multiple SSO providers. The plugin works only with JWT SSO.Installation steps are described in the Single Sign-On (SSO) Router Technical details page her...

Sisense Linux Multinode: MongoDB, Zookeeper and Data Recovery

Sisense Linux Multinode: MongoDB, Zookeeper and Data Recovery Problem: In unfortunate circumstances, there are situations where a Sisense Linux Multinode instance can become corrupted and the only choice to move forward is reinstallation. Sometimes i...

Assessing the Quality of Your Dashboard

Introduction The following article discusses how to assess the quality and adoption of your dashboard. Table of Contents IntroductionTable of ContentsHow to Measure a Dashboard's Quality?Planning Makes PerfectAssessing a Dashboard's QualityThe "Prac...

Taking your Dashboard to the Next Level

Introduction The following article discusses how to take a good functional dashboard to the next level. It mentions the relevant Sisense features available to help achieve your next goal. Table of Contents IntroductionTable of ContentsDashboard Co...

Sisense Community

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Knowledge Base Articles

Setting Date Filter Members to Specific Days of the Week in Sisense Programmatically

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Using Native Javascript Date Calculations To Modify Sisense Date Filters

Advanced Scripting for Sisense’s Simply Ask NLQ: Adding Currency Symbols to Pivot Tables

Modifying Simply Ask Natural Language Query Generated Widgets with Scripting

Limiting Date Range Filters in Sisense Dashboards

Programmatically Formatting Bar Chart Widget Value Labels in Sisense

UserReplaceTool - Automating Dashboard Ownership Transfers - Useful for Deleting User Accounts

Using the InternalHttp Function Within Scripts and Plugins

Resolving Export Limitations in Sisense

Advanced Pivot Widget Scripting - Combining Custom JAQL and the Pivot 2.0 API

How to List Dashboards and Data Models a User Has Access To

Expanding on Using Native Javascript Date Calculations To Modify Sisense Date Filters

Using the "desc" Description Parameter of a Sisense Dashboard via the REST API

Planning, Executing, and Monitoring your Dashboard

How to install new kernel or update existing one in Ubuntu

SSO Router Plugin Usage With Examples

Sisense Linux Multinode: MongoDB, Zookeeper and Data Recovery

Assessing the Quality of Your Dashboard

Taking your Dashboard to the Next Level

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense