Knowledge Base

Using the Metadata plugin, themes, and languages to limit duplication of dashboards

Using the Metadata plugin, themes, and languages to limit duplication of dashboards Do you end up with many copies of the same dashboard because your different users want to see their dashboards using their color schemes and their naming conventions?...

Funnel chart migration from Funnel Add-on to out-of-the-box widget

Funnel chart migration from Funnel Add-on to out-of-the-box widget Previously, we had the Funnel widget as a separate solution, which became a part of the product and is no longer supported as a plugin. (https://www.sisense.com/marketplace/funnel-wi...

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

Localization in Sisense, or How to Control Date and Numbers Format

Localization in Sisense, or How to Control Date and Numbers FormatIn Sisense, the format of data displayed, such as date and numbers in widgets or filters, is managed by localization. By default, localization is set to be automatically detected based...

Year over Year for the past x months

Analytical Need Sometimes we wish to see how we are performing in the last x months and comparing that to the previous parallel period. For example, we wish to see how we perform from Sep last year to Aug this year and compare it with Sep 2 years ...

How to Replace or Copy Dashboard Shares Using REST API

You will learn about common scenarios where we may need to copy or apply a new list of sharings for dashboards within this article. We need to export some dashboard corruption, remove them from the instance, and import them back. Copy the share lis...

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

How to embed an image from an external drive in the Sisense widget (a Blox template)

This article explains how you can embed images from an external drive (Google Drive) to the Sisense widget. Note: The solution is implemented with the help of the Blox plugin and on the L2023.3 Sisense version. In order to embed an image into the Blo...

Pixel Perfect Reporting Using Crystal Reports and Open Sisense (ODBC)

While Sisense provides powerful analytics and simple report printing, if pixel perfect report printing is required, additional tools like SAP Crystal Reports must be used. Purpose/Benefit Pixel Perfect reports can be designed which use data from a Si...

Trend Analysis

Trend analysis enables users to compare actual totals against measures derived from the data. This will enable users to compare actual results against derived amounts, and even project those amounts into the future. This example will use a simple ave...

Dynamic Dimension/Value Chart

Version: 1.1 Download the plugin attached Introduction This article explains how to install and configure the Dynamic Dim/Value Chart plugin as seen below. The Dynamic Dim/Value chart allow Dashboard designers to predefine multiple dimension and/or...

Reorder pivot columns by viewers

Need A common requirement for self service BI is to enable the viewers to save their own report. This can be achievable in Sisense if you are a designer of a dashboard. However, when you are a viewer, you cannot even re-order the pivot columns as...

Python Script to Export Dashboards to CSV File

The following Python script allows exporting dashboard data to CSV files. The script will export each widget to a separate CSV file. This new version of the script uses Sisense's REST API an eliminates the direct connection to the mongodb. Important:...

Extend The Functionality Of A Dashboard

Introduction This post describes the process for creating a new plugin that extends the functionality of the dashboard user interface. There are several different aspects that you can modify, this document will focus on the most common use cases. ...

Embedding Custom Visualizations Within A Widget

Introduction This document outlines the process for overriding an existing chart with a Highcharts Donut Pie chart. For a more robust solution, it is recommended to create a custom plugin as that would allow non-technical users to create charts wi...

Conditionally Colored X-Axis Labels On Bar Chart

Introduction The code below allows you to color the x axis labels for each category of a bar chart based on the color of a secondary series. It also then hides the secondary series from being plotted. Steps STEP 1 The first step is to create a bar c...

Retrieve All Widget IDs, Titles And Types In A Dashboard

1) Open the Developers Console (press F12 in Chrome.) 2) Navigate to Console tab: 3) In the console prompt line, enter the following script and press Enter: 4) prism.activeDashboard.widgets.toArray() 5) This results in a printout of an object with ...

Embedding Twitter Widgets In Sisense Dashboards

Introduction In this post we will demonstrate how to add a twitter feed within a dashboard. Business Case Viewing the latest tweets from key people in your industry may be an enhancing capability. Example Embedded Twitter Widget that is shown below...

Design a schema with more than one fact - Multi Fact Schema

Analytical Need We have multiple sources for our measures and multiple sources to slice & dice these measures. Modeling Challenge How do we build a schema that will enable us to perform our needed analysis? We will need to connect all of our t...

Analyze Period over Period - MoM / WoW / DoD

Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, ee want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in...

Sisense Community

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

Knowledge Base Articles