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

Knowledge Base Articles

Replace N/A Values With 0 In Indicators

This script replaces N/A values with 0 values. Applies for Indicator widgets.Before:After: Copy the following script and place it under 'Edit Script' in the designated Indicator widget:widget.on('render', function (w, q) { if (isNaN(w.queryResult.v...

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

Selectively Hide Widget Toolbar Buttons

Selectively Hide Widget Toolbar ButtonsThe widget script below shows a list of buttons that are available on a widget toolbar and how to hide each of them, so you can choose which ones you want to hide for any particular widget.Note that if you hide ...

TriAnthony by Community Team Member
  • 825 Views
  • 3 comments
  • 1 kudos

Bar Chart - Value Label From Secondary Series (Hidden)

In this post we will explain how to create a bar chart that shows a single bar, but displays value labels from a secondary hidden value series.Let's look at the below example, we have an bar chart that shows the two value series:In this case, we want...

intapiuser by Community Team Member
  • 1182 Views
  • 3 comments
  • 0 kudos

Managed Dashboards Panel

Download: Managed Dashboards PanelIntroduction:Customers create dashboards and sharing them with other. Sometimes, there are a lot of dashboards in the dashboard panel which can cause a mess and confuse them.For that, we created the plugin called 'ma...

intapiuser by Community Team Member
  • 767 Views
  • 3 comments
  • 0 kudos

Column And Line Chart Formatting

Introduction SiSense widgets can be customized using simple JavaScript.  Using this JavaScript our users can easily manipulate the look and feel of the widgets to suite their needs, and match the themes of their companies'.  Purpose/Benefit Sometimes...

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

Align Numeric Values to the Right on a Table Widget

Align Numeric Values to the Right on a Table Widget Disclaimer: Please note that this blog post contains one possible custom workaround solution for users with similar use cases. We cannot guarantee that the custom code solution described in this po...

ILLIA_0-1717421006641.png
ILLIA by Sisense Team Member
  • 213 Views
  • 0 comments
  • 2 kudos

Removing Value Labels And Markers From A Specific Series

When toggling the "value labels" switch of a widget's design pane, the labels are enabled or disabled for the entire chart.In case you have multiple series and you want to disable just one of them (typical when it gets too crowded on the plot), it is...

intapiuser by Community Team Member
  • 1438 Views
  • 4 comments
  • 1 kudos

Pivot2 Table Row Custom Sort

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

intapiuser by Community Team Member
  • 1514 Views
  • 1 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
  • 714 Views
  • 1 comments
  • 0 kudos

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

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

Indicators - Formatting Colors & Fonts

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

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

Improved (Enhanced) Color Manager Plugin

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

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

Giphy Widget

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

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

Modifying X Axis Labels

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

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

Advanced Quadrant Chart

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

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

Reset To Default Filters When Loading Dashboard

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

intapiuser by Community Team Member
  • 2381 Views
  • 4 comments
  • 0 kudos
Labels