Widget & Dashboard Scripts
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Card View Customization

Before:After:Dashboard script for creating card view:dashboard.on('widgetready',function(d) { $('.dashboard-layout-column').css('background-color', '#f0f0f0'); $('.dashboard-layout').css('background-color', '#f0f0f0'); $('.dashboard-layout-c...

intapiuser by Community Team Member
  • 1324 Views
  • 4 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
  • 853 Views
  • 1 comments
  • 0 kudos

Gradient Conditional Formatting In Pivot Tables

Conditional formatting of background colors in pivot tables is one of the best ways to draw attention to numbers, but still provide a clean visual.  The use of data bars creates a lot of visual noise, whereas background colors are subtle and act more...

intapiuser by Community Team Member
  • 2215 Views
  • 5 comments
  • 0 kudos

Export buttons [Excel, CSV] for the Pivot widget

Export buttons [Excel, CSV] for the Pivot 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 post ...

ILLIA_0-1691915444285.png
ILLIA by Sisense Team Member
  • 1514 Views
  • 1 comments
  • 2 kudos

Show only Markers of a Series (Hide Line)

Sometimes, in a column or bar widget, it is useful to have a measure that gives us additional information but cannot be plotted as a Bar or Column or a Line since the measure is either on a different scale or because it does not make logical sense to...

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

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
  • 1286 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
  • 1130 Views
  • 3 comments
  • 1 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
  • 2622 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
  • 372 Views
  • 0 comments
  • 2 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
  • 1713 Views
  • 1 comments
  • 0 kudos