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

Knowledge Base Articles

Overlay Data On An Image

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

intapiuser by Community Team Member
  • 267 Views
  • 1 comments
  • 1 kudos

Sharing All System's Dashboards With A Specific User

Sometimes, for example when adding a new admin user, you might want to share all of the dashboards in the system with that user. In order to do that, you can use the following Python script: import requests import time import json user_name = 'omer.s...

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

Creating One Total In A Stacked Column

When choosing “Stacked Bar Chart” and select “totals” and we have positive and negative values, we get two totals. Totals for the positive numbers at the top Totals for the negative values at the bottom.If we want to get only one total that sums both...

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

Customize Value Labels

Download: Custom Value Labels Introduction This article explains how to customize how value labels are displayed on common chart types. Purpose/Benefits When you have limited screen real estate, you may see your value labels overlap each other. Addin...

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

Automatic Carousel Filtering

Blox Carousels are great, but sometimes you want the carousel to automatically filter when the "previous" or "next button" is clicked.The easiest way to do this is to add a standard blox filter button on each blox slide which we will hide: through th...

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

Wiser Clear All Filters Plugin

WiserClearAllFiltersPlugin on GitHubDownload: WiserClearAllFiltersPlugin (click the latest .zip) PURPOSE/BENEFITSAfter publishing a dashboard with preset filters to a user, the user may further interact with a dashboard and change the filters being s...

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

Keep Only 'Grand Totals' And Hide All Other Rows In A Pivot Table

Challenge: Rarely we would have to hide all the rows of pivot table and only show the Grand Total Rows. This will help us preserve the context provided by the dimension used in the rows of the pivot table but hide it to show the "Grand Total" only. S...

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

Track Dashboard Usage With Google Analytics

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

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

Pivot2: "Add Sparklines In Pivots" Re-Implemented

Introduction This plugin was created to allow dashboard designers to create sparklines within a pivot table. This plugin currently supports line, area, and column charts as the sparklines. Steps The following steps will walk through the process of ad...

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

Right Align Numeric Dimensions In Pivot And Table Widgets

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

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

Remove Columns That Contain All Nulls From Pivot Table

ApplicationUse this script in a pivot table where a column may have all NULL values to clean up the UI.The irrelevant columns are dropped after being loadedwidget.on('ready', function(){ var tlen = parseInt($('.p-container thead tr td').last().prev()...

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

Formatting Pivot Header Rows And Columns Via CSS

Introduction Use this script to format the header rows and columns of a Pivot table. Instructions Create a Pivot table > Save It > Go back to the Edit Window > Edit Script. widget.on("ready", function(w, args) { //header columns var $ps1 = $(".p-gran...

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

Dynamic Offset For Date Filters

Introduction:The following script will allow you to get the functionality of "Last x days" for any chosen date in the dashboard filter.Steps:1. create a dashboard filter of type "days" and set it up to be a radio button:2. Paste the following in the ...

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

Sort Both Axes In Scatter Chart

In order to sort both axes in the Scatter chart you might need to use the following script under the "Widget Script" levelvar xOrder = 'asc' //also, this value can be desc var yOrder = 'asc' widget.on('beforeviewloaded', function(scope, args) { var s...

intapiuser by Community Team Member
  • 377 Views
  • 1 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: