Download: Images in Bar Chart NOTES: This plugin works with Sisense version 6.6.1 or later. This plugin adds additional functionality to bar charts, allowing them to show custom images in the end of each bar. This could be useful to make, for insta...
Migrating Assets Across Environments Leveraging GITSisense released its Git Integration for Linux version 2022.10. With the GIT GUI in Sisense, you can can do a lot of exciting things like version control or integrate into CI/CD pipelines. I went ahe...
This script replaces N/A values with 0 values. Applies for Indicator widgets.Before:After: Copy the following script and place it under 'Edit Script' in the designated Indicator widget:widget.on('render', function (w, q) { if (isNaN(w.queryResult.v...
Selectively Hide Widget Toolbar ButtonsThe widget script below shows a list of buttons that are available on a widget toolbar and how to hide each of them, so you can choose which ones you want to hide for any particular widget.Note that if you hide ...
In this post we will explain how to create a bar chart that shows a single bar, but displays value labels from a secondary hidden value series.Let's look at the below example, we have an bar chart that shows the two value series:In this case, we want...
Download: Managed Dashboards PanelIntroduction:Customers create dashboards and sharing them with other. Sometimes, there are a lot of dashboards in the dashboard panel which can cause a mess and confuse them.For that, we created the plugin called 'ma...
Introduction SiSense widgets can be customized using simple JavaScript. Using this JavaScript our users can easily manipulate the look and feel of the widgets to suite their needs, and match the themes of their companies'. Purpose/Benefit Sometimes...
Align Numeric Values to the Right on a Table Widget 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 po...
When toggling the "value labels" switch of a widget's design pane, the labels are enabled or disabled for the entire chart.In case you have multiple series and you want to disable just one of them (typical when it gets too crowded on the plot), it is...
In a custom column, add a prefix number followed by a period and a space to the dimensions you want to sort in pivot.For example, if we have a column called Category with the following categories:First CategoryAnother CategoryCreate a custom column c...
Introduction when adding numeric dimension to pivot and table widgets in the rows section and not the value section (in cases where the numeric value is an attribute and not a measure) you can change the alignment of the number dimensions to the left...
Sometimes we have data that is not easily represented by an existing chart, such as presenting steps in a cycle or a sequence of events. One JavaScript +HTML technique that we can use for this is to overlay an image with text. In this example, we ha...
How to Use "OR" Filter Condition on a Widget Level | JavaScript This article provides an example JavaScript code snippet to have the ability to use the "OR" filter condition on a widget level. Currently, the Filter Relations Editor in Sisense allows...
Stack 100 Bar Chart - How to Add Percentage of Total (Contribution) to Value Labels This article provides an example solution on how to add a percentage of the total (Contribution) to the data labels in the stack 100 bar chart. How to use it? Open...
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...
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...
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...
How to Customize Pie/Bar/Column/Area/Line Chart Data Labels If you find yourself needing to modify data labels on a widget, and the built-in capabilities do not allow you to achieve your goal, it might be possible to customize those values with the ...
OverviewSisense's default behavior is to use values directly from the Elasticube to set the X-Axis. But what if you want to do more? Modifying the x-axis labels is very easy and very flexible. Let's look at the base code.widget.on('render', function(...
ObjectiveDesign a quadrant chart based on X and Y axis averages with conditional formatting.StepsCreate standard scatter chartCreate a value in break by and assign the integer 1 to itCreate Aliases for multipasses by the Point dimension for the X and...
