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 ...
Introduction This post will give the JavaScript necessary to format the Widget Title.Purpose/Benefits When formatting your dashboard, manipulating the Widget Title to match your other formatting will give the dashboard a more personalized feel.Exampl...
Usage PivotAPI to Beautify Data On Pivot In this article, we will review the capabilities of PivotAPI to customize cells. Additionally, we will review important properties, as well as some tricks, we can use to visualize data in a more beautiful way...
IntroductionThis post and it’s JavaScript will Allow you to customize the data point ‘markers’ on a line chart to whichever image you would like to display. Purpose/Benefits Add some creativity to the standard Line chart by adding an image of your ch...
BloX Write Back Form to a Source Database Sisense BloX Database Writeback This guide demonstrates setting up a simple BloX widget to enable front-end users to write data back to the database. While this guide specifically uses AWS lambda to execute ...
IntroductionAdding a visual representation to your measures will allow you to read the bigger picture in a glance, recognize trends and have better user engagement to your dashboards.Comparing data columns or even different values within the same co...
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...
Deploying Sisense with custom-defined storage classes (rwxScName / rwoScName) Sisense can be installed on different platforms (RKE / OpenShift / EKS / GKE / AKS, etc) with a variety of storages. Usually, you just need to specify the exact supporte...
Download: Latest version (Sisense v7.0+), legacy version (Sisense v6) Introduction This article explains how to create filter bookmarks using Sisense. Purpose/Benefits It is easy for dashboard users to add/update filters on a given dashboard, but an...
Description Shifting between external sources that are based on different scripting languages is not an easy task. When there is a requirement to query a secured widget's data to an external source (Such as JQuery, JavaScript,HTTP etc.), you will ne...
There is a known issue that is planned to be fixed in the Sisense L2023.6+. If you install Sisense on CentOS or RHEL version >= 8 the old EPEL 7 repositories are used instead of EPEL 8 To fix this issue: Locate in the installation folder and open i...
This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC ...
Introduction This script displays a total line over your stacked column / bar chart. It also works with the classic (side by side) grouping.Instructions Create your chart and add the following script. Edit > Options Menu > Edit Script.Note: You can m...
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...
Here is an example of a widget script you can use to create a Waterfall Chart using the standard Column Chart widget.First, create a column chart with multiple measures/values.In the example below I have a starting price, and then two adjustments (th...
IntroductionThis article will explain how use MAX() / MIN() functions on date fields using Pivot2.Business CaseSometimes we need to present the last / first date that a certain action occurred in or planned to.ExampleFor example, we want to present w...
Apply the following script on a table with aggregation's widget script to create a row with Grand Totals.This will be considered as just another value and may not always appear on the first page of results if results are paginated.widget.on('processr...
This article demonstrates two methods to count the number of days that passed from one event to the other for a specific category (i.e number of days passed between one sale to another by sale code). The preferred way to do this calculation is in a c...
How to Get a Vertical Line in the X-Axis in a Line Chart This article explains how to get a vertical line in the x-axis in a Line chart and covers 3 use-cases: 1. A vertical line on a maximum value (metric). 2. A vertical line when x-axis category ...
How to Update Live Model Dataset Configuration Through API Call In this article, we'll discuss how we can update Live Model query settings through API calls. Dataset resource represents a single data source of your Datamodel - for example, if your D...
