Knowledge Base

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

Sisense Compose SDK

Sisense Compose SDKThe Future is ComposableIn the fast-paced world of data-driven applications, developers are constantly seeking innovative ways to create customized data products that seamlessly integrate into their projects. Sisense has stepped up...

Plugin - customLogoLink

Plugin - Set Custom Link Overriding default In Top Left Logo Icon Description This plugin allows changing the link of the top-left Sisense or white-labeled logo on the server's home page to a custom URL. Disabling the plugin will restore the log...

Screen Shot 2024-02-23 at 5.07.40 PM.png

Conditional Coloring with Scripting in Sisense Polar Bar Charts

Polar Chart Widget Conditional Coloring When working with polar chart-type widgets in Sisense dashboards, it can be helpful to set coloring conditional on the data returned from the data sources. This can improve the utility of the widget. However,...

Demonstrating ComposeSDK Styling Of Sisense Dashboard Widgets

Demonstrating ComposeSDK Styling Of Existing Sisense Dashboard Widgets When developing ComposeSDK embedded applications, there are three principal techniques for embedding or converting an existing Sisense widget. Discussing each method, and some o...

Screen Shot 2024-03-12 at 2.06.41 AM.png

Converting an Existing Sisense Widget to a Dynamic ComposeSDK Widget Component

Converting an Existing Sisense Widget to a Dynamic ComposeSDK Widget Component Using either the widget Sisense API's, or the Sisense widget JS API object, it is possible to determine all components and parameters of a widget required to create an eq...

Screen Shot 2023-11-14 at 6.54.54 PM.png

Screen Shot 2023-11-14 at 6.54.35 PM.png

Plugin - Custom Coloring of Bar and Column Chart Type Widgets (barChartCustomColor)

Plugin - Custom Coloring of Bar and Column chart-type widgets This plugin modifies the color scheme of bar and column chart-type widgets to match the current color palette of the dashboard. Installation To install this plugin, download and unz...

Screen Shot 2024-04-04 at 1.21.28 AM.png

Screen Shot 2024-04-04 at 1.28.47 AM.png

Plugin - DisableLogoLink

Plugin - Disable Link To Sisense Server Homepage In Top Left Logo Icon This plugin disables the link to the home page of the top left logo in the Sisense UI. The plugin also removes the logo icon being treated as a link on mouse hover. This logo im...

Using "useGetWidgetModel" to Embed an Existing widget in ComposeSDK

Using "useGetWidgetModel" to Embed an Existing Widget in ComposeSDK When developing ComposeSDK embedded applications, there are three principal techniques for embedding or converting an existing Sisense widget. Discussing each method, and some of th...

Screen Shot 2023-11-18 at 4.53.33 PM.png

Using the Color Palette Parameter of Sisense Dashboards in Scripts and Plugins

Using the Color Palette Parameter of Sisense Dashboards in Scripts and Plugins Like many other dashboard parameters, the color palette of a Sisense dashboard can be accessed and modified in scripts and plugins for customization and addi...

Screen Shot 2024-01-10 at 9.20.12 PM.png

Plugin - HideChartTypeByGroup

Plugin - Hide Widget Type in Chart Type Dropdown From User Groups This plugin hides widget types from the widget selection dropdown menu, for user groups set in the config of the plugin. The widget types hidden are set in the config. Widgets o...

Screen Shot 2023-11-08 at 8.55.33 AM.png

Screen Shot 2023-11-08 at 8.53.31 AM.png

Sync Blox Input Element with Current Filter State

Sync Blox Input Element with Current Filter State When creating a Blox widget and altering a filter within a dashboard or widget, it is sometimes advantageous to modify the default behavior, so that upon activating a Blox action, the Blox widget in...

Elevate Your Data Product’s Quality with Streamlined Version Control leveraging Our Git Integration

Elevate Your Data Product’s Quality with Streamlined Version Control Leveraging the Sisense Git Integration! In today's CI/CD ecosystems, efficient asset migration from development to production environments is crucial for delivering high-qualit...

BloX - A Technical Introduction

BloX - A Technical Introduction To start, download the attached file ‘BloXTutorial-Styling.dash’ file and import this into your Sisense environment. This dashboard uses the ‘Sample Ecommerce’ data model and contains all iterations of the BloX widget...

Funnel Charts In Python

Funnel charts are a great way to represent any drop-offs in sample size throughout a series of steps. Using a little bit of Python handiwork in Sisense for Cloud Data Teams' R/Python integration, we can easily create this chart type. A common use ...

Sankey Diagrams With Plot.Ly In Periscope

Sankey diagrams are a very easy-to-digest way to look at the flow of objects between different points. The example we will walk through here is a basic Sankey overview, leveraging data from a fictional gaming company. The emphasis of this post is...

Text Mining With SQL

One of the recent questions I had to answer focused on analyzing text data. How have you solved this problem in the past? I was not sure how to create an optimized solution for both efficiency and completeness. My solution I came up with used a joi...

Generate Series Of Dates In Snowflake

As Snowflake doesn't have a native generate_series function, here is our solution to generating a table of incrementing dates, starting from the current date, in Snowflake. It is currently set to generate 1095 rows (3 years) of dates. select ...

Chart Type - Radial Bar Chart In Matplotlib (Python)

Here's a script that takes a data frame with two values, the current and benchmark, and returns radial bar charts to plot progress toward a goal. You can also choose a color using the color_theme parameter that takes values 'Grey', 'Purple, 'Bl...

Sisense Community

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

Knowledge Base Articles