The .describe() function in Python is really handy for exploratory analysis! Sometimes, you would want to display this as a table on a dashboard, but how? The output is typically printed out as text, not as a dataframe.Fear not, getting this into a d...
Question How to Calculate YTD by Month in a Pivot Table? Answer If you want to show YTD by Month next to your monthly amount you can utilize the "Running Sum" Quick Calculation. If you want to show this next to the monthly amount, just bring in th...
IntroductionUse this script for granular formatting of an Indicator Widget. Instructions:Create your indicator widget and add it to the dashboard. Select the edit button and choose the Edit Script from the options menu on the top right. Add the fol...
Restoring missing connector Introduction Sometimes connectors can go missing for some reason, leading to a breakdown in data connectivity. Restoring these connectors is crucial to maintaining a smooth data flow within your Sisense environment. This...
PDF export Troubleshooting NOTE: This is an updated version of the following community article - https://community.sisense.com/t5/knowledge/error-exporting-to-pdf/ta-p/9025 Let's review 2 possible problems with the PDF export - the export fails comp...
Email Troubleshooting NOTE: This is an updated version of the following community article - https://community.sisense.com/t5/knowledge/email-troubleshooting-sisense-7-2/ta-p/8941 This guide will demonstrate a few official first steps for troubleshoo...
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...
This article will explain how to create reset to default filters button in BloX This helps in case you want to provide this icon functionality on the dashboard and not just in the Filters panel. Create a new custom action with the below code: *...
User Parameters Use Case - Automatic Currency ConversionThis article explains one of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cases).In addition to connection settings, Use...
User Parameters Use Case - Automatic Time Zone Conversion This article explains one of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cases). In addition to connection settings,...
Download linkThe Color Manager plugin, originally by Tommy, is a great plugin which allows you to define specific colors for specific categories (and not to values, which is the way Sisense works by default). Furthermore, the colors you specify for a...
This article will cover the below options:Section 1- Buttons + Highlight Background-Color - Creating Buttons of date granularity slicing options (Alternative for Tabber plugin)ORSection 2 - Dropdown List - Creating Drop-down list with Date granularit...
Disclaimer: Please note that this blog post contains one possible custom workaround solution for users with similar use cases. We cannot guarantee that the custom code solution described in this post will work in every scenario or with every Sisense ...
This article covers the steps to change the date granularity of a widget using BloX actions along with the dropdown input of BloX. In this post, we shall achieve the functionality with the help of single-select BloX buttons that has some color animat...
User Parameters Use Case - Enforcing Data Isolation / Row-Level Security Rules from Source DatabaseThis article explains two of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cas...
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...
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...
Download: GIPHY WIDGETINTRODUCTIONThis article explains how to install and use the giphy widget.This is an extension of the existing image widget allowing you to define a keyword and with the giphy api display a random image driven by the keyword. W...
Three tips for new users working with Sisense's REST API for the first time.1. If you're running API calls through our Swagger UI (ie, by going to Admin -> REST API -> REST API Reference), you do not need to generate and pass an authentication token....
Exporting Options in SisenseJS SisenseJS is a powerful tool that allows embedding widgets from Sisense into external applications. Despite it being a very straightforward way of embedding, SisenseJS has some missed functionality. For example, there ...
