Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Predictive Trend Line Plugin

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

intapiuser by Community Team Member
  • 599 Views
  • 0 comments
  • 0 kudos

Pivot2: "Transpose A Pivot Table Plugin" Re-Implemented

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

intapiuser by Community Team Member
  • 787 Views
  • 0 comments
  • 0 kudos

Candlestick Chart Plugin

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

intapiuser by Community Team Member
  • 396 Views
  • 0 comments
  • 0 kudos

Bar Chart - Reduce Length Of The Display Name

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

intapiuser by Community Team Member
  • 234 Views
  • 0 comments
  • 0 kudos

Clone Field

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

intapiuser by Community Team Member
  • 177 Views
  • 0 comments
  • 0 kudos

How to Create/Read/Update/Delete users - python

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

intapiuser by Community Team Member
  • 1281 Views
  • 0 comments
  • 0 kudos

Venn Diagram

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

intapiuser by Community Team Member
  • 402 Views
  • 0 comments
  • 0 kudos

Center / Zoom Scatter Map

Introduction The following article will explain how to center and zoom scatter map.Purpose/Benefits This script allows you to center and zoom a map according to a given latitude and longitude.Example In the Example below we want to center the map to ...

intapiuser by Community Team Member
  • 460 Views
  • 0 comments
  • 0 kudos

Disable Mouse Scroll Zoom On Scatter Map

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

intapiuser by Community Team Member
  • 377 Views
  • 0 comments
  • 0 kudos

How To Abort Widget Query In `Beforequery` Event

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

intapiuser by Community Team Member
  • 248 Views
  • 0 comments
  • 0 kudos

Waterfall Chart (HighCharts)

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

intapiuser by Community Team Member
  • 1174 Views
  • 0 comments
  • 0 kudos

Parameters Plugin additional solution

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

intapiuser by Community Team Member
  • 367 Views
  • 0 comments
  • 0 kudos

Dynamic Formula Changer (Based On User Group)

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

intapiuser by Community Team Member
  • 370 Views
  • 0 comments
  • 0 kudos

Changing Indicator Styles Using The Indicator API

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

intapiuser by Community Team Member
  • 390 Views
  • 0 comments
  • 0 kudos

Tech Book Creator

It basicly does the same has the handbook creator. However this script creates CSV with dashboard_id ,widget_id ,title ,subtype, datasource ,panel_type ,panel_val.We are looking into adding filters etc aswell. Config settings.ymlEdit settings.yml wit...

intapiuser by Community Team Member
  • 258 Views
  • 0 comments
  • 0 kudos

Pivot Table Value Difference

Question: How to find value difference in Pivot table VALUE field "Total" which divides values by Month Columns.Solution: You can solve this by the following script:var columns = 3; var avg = 0; var val = ''; var temp=0; var title = "text"; widget.o...

intapiuser by Community Team Member
  • 333 Views
  • 0 comments
  • 1 kudos

Rotating Text In The Text Widget

Dashboarding Need Often, we would need to beautify our dashboard in a logical sense and will have the need to rotate the text. Especially when we group our metrics horizontally, every row area will represent one group. To label each row, having a tex...

intapiuser by Community Team Member
  • 344 Views
  • 0 comments
  • 0 kudos
Labels