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

Knowledge Base Articles

Dashboard Handbook Creator

  This script creates a word-document of the given dashboard IDs. This document includes dashboard name and Widget name,description and image.  Config settings.yml Edit settings.yml with your information ! Be carefull running this script. It searche...

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

Python Script to Export Dashboards to CSV File

The following Python script allows exporting dashboard data to CSV files. The script will export each widget to a separate CSV file. This new version of the script uses Sisense's REST API an eliminates the direct connection to the mongodb. Important:...

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

Embedding a Google Doc or Sheet in Your Dashboard

The iFrame Widget Plugin is a powerful tool that enables you to embed any web page that you wish into your dashboard, using its URL. A great use of the iFrame widget can also be used to Embed Google Docs or Sheets. The quick access to the document ...

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

3D Pie Chart Plugin (Donut3D)

Download - 3D Pie ChartIntroductionThis article explains how to import the 3D Pie Chart from D3 as a plugin in Sisense.Purpose/BenefitsThe 3D Pie Chart provides user with the ability to illustrate numerical proportion in 3D and also creates animation...

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

The Smart Label

Download: Smart Label   Introduction The following article describes steps needed to add to create smart text widget to present ElastiCube fields as text.   Implementaion Steps Extract the folder in the attached zip file into \...\Sisense\PrismWeb\p...

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

How to Edit Layout Pivot Table Break By Columns

If you want to change the style of both columns under Break By category, you can try to use the script below and adjust it to your needs:widget.on("ready", function(w, args) { var style = { 'font-size' : '12px' ,'font-weight' : 'bold' ,'color' : 'wh...

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

Bullet Chart

Download: Bullet Chart  Introduction This article explains how to import a bullet chart plugin into Sisense.The bullet chart plugin support column charts and bar charts. The plugin supports version 5.8 and up. Bullet chart is used to compare the dat...

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

Set The Background Color Of An Indicator

IntroductionUse this script to set the background color of the indicator widget.InstructionsCreate an indicator widget and add the following script// set the background color here var bgColor = '#F8F8F8' widget.on('processresult', function(w, e) { ...

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

Format Axis Labels In Charts

IntroductionIn this post we will explain how to format the axis labels in charts, remove truncation, add new line etc.Purpose/BenefitsPresent long labels, break text to multiple line.ExampleCreate chart widgetEDIT WIDGET SCRIPTThe following script wi...

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

Change Axis/Series Data Limitation

IntroductionThis article explains how to change default data limitation of X and Y axis for scatter charts.When there are too many categories in the X/Y axis or too many series, Sisense limits the number of categories/series to display. StepsSTEP 1 -...

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

Dynamic Pivot Table Heat Map

IntroductionThis article describes how to dynamically color cells based on values included in the entire view.The visualization method assists in seeing trends across the entire pivot table. Retention, Cohort, and usage analyses benefit the most from...

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

Sisense For Adobe Photoshop

Sisense plugin for Adobe Photoshop The plugin helps customers to build beautiful widgets using the powerful graphic tools from Adobe in a zero code environment. This guide will explain step by step how to install and use the plugin.Video instruction...

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

Conditional Formatting Of Grand Totals

Please put this code into the widget script of the pivot:widget.on("domready", function(w, args) { // column 2 formatting, using the underlying value of a <td>, instead of the surface text of the <div> // <td> has the value attribute w...

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

Resend Invitations to Inactive Users in Bulk

Steps: 1) Download Python and install it on your PC or the Sisense machine (make sure to add python to the PATH to easily initiate installation of directories). 2) Run CMD and type the following commands to add libraries used as part of our solution...

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

Python 3 Script to Import Many ElastiCubes

Introduction The attached script is intended to loop through all ElastiCube folders in your ElastiCubeData folder and import them. Business Case This solution has a couple of possible use cases.  The first is to facilitate migrating a Sisense environ...

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

Inserting New Users From CSV File

In some cases you would like to add many users manually and in bulk, and won't want to go through the process of entering one at a time. With the following python app you will be able to insert users from a CSV by just running it. Steps: Download th...

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

Dynamically Change The Filter Header Colour

You can use this as a dashboard script: var colorFilterName = 'L4L Starting Period'; var backgroundColor = 'yellow'; dashboard.on('refreshstart', (d, args) => { $('.ew-i-caption:contains(' + colorFilterName + ')').parent().css('background-color...

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

Adding A Range Area To A Metric In A Line Chart

IntroductionUse this script to add a range area or a range bar to a line chart. e.g. When plotting the metric you can superimpose it over a range area.Instructions#1Create a line chart, add the 2  fields which comprise the lower and upper limits of t...

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

Progress Meter - With Animation

Progress MeterThis is a plugin for Sisense that will enable a new chart type called Progress Meter. This chart type is intended to measure how much progress has been made toward a goal.InstallationInstall is quick and easy:Download the repositoryUpl...

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

Detect ElastiCube Build Status

Using the code from this article, a user can detect whether or not an ElastiCube is currently building, and refresh if the ElastiCube is not building. More importantly, the code in this article can be used as a framework for utilizing REST API functi...

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