IntroductionThis article explains how to adjust Pivot tables to use standard financial formatting of numbers. This means showing negative numbers as always RED with parentheses instead of a minus sign, as well as populating empty (null) cells with ...
BackgroundFor better visualization, sometimes you want to overlay your area chart with a line chart, so that you can change the outline color of each area. You can also change the opacity of the areas. See below screenshots as examples. Before: The c...
DOWNLOAD LINKPLUGIN OVERVIEWThe purpose of the plugin is to provide a colorful visualization to represent data sets that have several points and can be grouped into categories. I have created this simple streamgraph, which is based on Highcharts - S...
This code will index against the first value of a series of a line chart. For example, the first value will always be 100%, then the subsequent values are displayed as a percentage of the initial value. An example from the federal reserve bank of dal...
Download: Plugin Scatter Map Auto ZoomIntroduction The following article will explain how to dynamically center and zoom a scatter map, based on the data points. So if your map defaults to a view of the US and then changes to Europe, the map will au...
Introduction A sample code to demonstrate adding shares using the Sisense API in .NET. The programs flow is a follows: Retrieve the authentication token using:Retrieve userID using:Retrieve the current shares for the dashboard using:Share the dashb...
Forecast and Trends functionality is now available directly within Sisense. Learn how to enable it for Sisense versions Windows 8.1.1 and above or Linux 8.2.1 and above, here: ForecastingTrends If you're using an older version of Sisense, or don’t h...
Introduction This plugin allows users to set the measures as rows and slice them by different dimensions such as different date resolutions. Implementation Steps In order to implement The Transpose Pivot Plugin, please follow the listed steps below...
Version: 1.0Download: Candlestick Chart PluginIntroduction:This article will explain how to add a Candlestick chart to your Sisense instance.Purpose/Benefits:The Candlestick chart is a style of financial chart used in technical analysis in order to d...
The script below can be used to reduce the length of the labels in the bar chart to a specified length and add an ellipsis (if it reduced the length).The script will reduce the length of the displayed names if it greater than specified varlength whet...
Download: Clone FieldIntroductionThe field Clone plugin allows you to easily create a duplicate copy (clone) of an existing field within a widget.PurposeCurrently, when creating a measured value, using the same field as the one presented in a widget'...
Here is a python script to that describes how to manage users with sisense api:What you need: rest api key token (not relevant for v6.5+, need to use /api/v1/authentication/login) admin credentialspython installedimport time import json import urllib...
Venn DiagramDynamic Venn diagram on your dashboard!Download Now! Venn V1SIMPLE INSTRUCTIONS:Venn data structure sample:Dim table: Values table: Fruit,Bread,Dairy,KitchenPut the Venn folder into sisense’s plugins folderLoad the sample dataCreate a di...
Horizontal Marker With Drop-LineHorizontal Marker Without Drop-LineFirst change the chart to a line chart and enable markers. Turn it back to a column chart and proceed to add the code.Note:The second measure becomes the affected item. If you want to...
Purpose/Benefits:When mouse scrolling on a Sisense dashboard that has many widgets - a Scatter Map can inadvertently be affected. This script will help keep the map in place.Widget Code:widget.on("beforeviewloaded", function (widget, args){ var map ...
Preventing a query from executing in the `beforequery` event is as simple as assigning an empty object `{}` to the `query` event argument.This will result in the query not being sent, and the widget rendering in its "no results" mode.Example:widget.o...
Download: Waterfall ChartVersion : 1.1Introduction This article explains how to import a Waterfall Chart from HighCharts as a plugin in Sisense.Purpose/BenefitsWaterfall charts are a common way to represent the variance over time for a given dimensio...
Step 1: The Fact TableHere is my fact table, it contains an item and a price as well as a fake key. This will be necessary for the next steps.Step 2: The Parameter TableThe key element is to rethink of a parameter as a dimension. So the first step is...
Download: GitHub Link Version: 1.0.0 Introduction This article explains how to install the plug-in and how to interact with the configuration file. Purpose/Benefits This plug-in will change the current formula applied to widgets on a dashboard to a ...
Indicator styles are modified by an API and the reference for making such changes can be found here, within the Javascript API documentation on our developer site:https://developers.sisense.com/display/API2/JavaScript+API+Reference#JavaScriptAPIRefer...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
