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...
Purpose/BenefitSometimes it is convenient to always reset the filters to a default state when opening a dashboard. This post describes how to achieve this with a little bit of JavaScript. When users will often be resetting filters to a default stat...
Introduction When our chart x-axis have long labels, by default the SISense Web application will not render the entire label. For this, we can use the following script which wraps the text and breaks the text line for every other white space. In addi...
Render existing HTML code stored in your data modelFollow the steps below in order to URL clickable within a pivot table. Some steps are different depending on whether your Sisense instance is running on Windows or Linux. You can check whether your S...
Plugin Overview This plugin registers every page view from your Sisense instance to your Google Analytics account. https://analytics.google.com Configuration You must specify your Google Analytics "tracking ID" by editing the main.js file.By default...
When would I use this plugin?If there's a need to copy files from a remote server to the Sisense server before a build begins and delete them after the build is completed to save disk space. Useful for CSV and Excel files. Setting up the plugins:1) L...
Sometimes you might want to change the color of your pivot columns based on a condition - for example coloring the column in green if the cell's value is equal to a specific word and red if not:STEP 1 - ADD THE FOLLOWING SCRIPT TO YOUR PIVOT'S EDIT S...
IntroductionIn some cases you might have a URL’s in your fields in the cube, this post will show you how to modify URLs placed in rows of a Pivot table into clickable links.Purpose & BenefitsThis will allow you to jump to either internal or external...
Download: Custom Chart OptionsVersion: 1.0.0Created Oct-23-2019 by Steve Lewis (thanks to code re-used from Elliott Herz's Custom Bar/Column chart plugin) Current Version: V1.0.0 Tested on Sisense Version: V8.0.1.10112 Description: Sisense allows a c...
IntroductionRegression line helps us to predict values of one variable, when given values of another variable.Linear regression assists in predicting trends and improving data analysis.StepsA regression line can be added to all widgets with both y an...
