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

Knowledge Base Articles

Tabs For Pivot Tables

The main intention is to organize the pivot table in case it has too many columns. The script will add a tabber that hides and show a specific set of columns. The code is completely fitted to our needs. If you want to use it, you have to replace ever...

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

Set Max Value For Y Axis In A Chart

There might be cases where one needs to increase the height of the Y-Axis in a chart to ensure that the value labels are not removed while the chart is being responsive.  The following script allows you to increase the max Y-Axis value by an X percen...

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

Remove Formulas Backgrounds

Download: Remove Formulas BackgroundThe plugin removes the blue background color from aggregations and calculations in the Advanced Formulas menu.STEPSSTEP 1 - ADD THE PLUGINDownload the attachment and unzip the contents into C:\Program Files\Sisense...

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

Grand/Subtotals For Specific Values In Pivot Widget

Download: Control Sub Grand Total  Introduction The following forum post explains how to control Grand totals and Subtotals in the pivot widget. Purpose When we want to display Grand/Subtotal it's not always relevant for ALL values/columns, but only...

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

Rotate And Wrap Text In X-Axis Labels

This post explains how to rotate and wrap text in the x-axis labels. Begin by copying the following code into the widget script. widget.on('beforeviewloaded', function(widget, args){ var newmaxCharactersPerLabel = 25; //Set length of the line length...

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

Mapping Arrow Keys To Control Dashboard Panels

This script allows you to map the left arrow key to control the left dashboard panel, and also maps the right arrow key to control the right dashboard panel. Also using this approach, you can map any keyboard key to other types of functionality.This ...

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

Convert Negative Sign To Parentheses In Pivot

Introduction By default SiSense formats negative numbers by using the minus sign, like -1500. Some people prefer to format negative numbers by using a parenthese, like (1500). This article shows how to edit a widget's script to format the numbers thi...

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

Set Default Dashboard Per User Group

Download: Sisense v6 Download, Sisense v7 DownloadIntroduction When a user logs into Sisense Web, they get taken to a standard home page.  This plugin allows admins to define default dashboards for each user group.  So instead of landing on a home pa...

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

Extend The Functionality Of A Dashboard

Introduction This post describes the process for creating a new plugin that extends the functionality of the dashboard user interface.  There are several different aspects that you can modify, this document will focus on the most common use cases.  ...

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

Get CSV Of ElastiCubes, Tables, And Fields Metadata

IntroductionThis script exports to CSV a complete list of your ElastiCube servers, ElastiCubes, tables, fields, and field data types.Prerequisites Tested in Python 3.6. Requires Sisense 7.1+.Python Packages Requests JSON PandasSteps1. Download and un...

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

Custom Filters

Download: Custom FilterIntroduction This article explains how to create custom filters as a plugin in Sisense.Purpose/BenefitsSisense comes with a set of native/robust filter options, but these are always displayed on the right side of the dashboard....

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

Filter Chart By Underlying Members Of An Aggregate

Download: Members FilterIntroduction This article explains how to create a chart that allows filters to be created from the members that make up a group.Purpose/BenefitsSisense's New Widget Wizard allows users to quickly group data into categories fo...

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

How To Create A Dash Line In Line Chart

As a user sometimes I would like to change the format of one line to a dash line.To apply the dash file enter the "Edit Script" within the widget editor and insert the script bellow. Change in the 1st line of the code the "name of value" to the name ...

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

Manually Order A Column Chart

Introduction Sisense's built-in ordering allows you to sort columns by a displayed value, or in alphanumeric order. However, some situations require a more specific order. This article shows you how to utilize a specific order for the columns in a c...

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

Shared Tooltip For Scatter Chart

  Download: Shared Tooltip Introduction The following article describes steps needed in order to add a shared tooltip to a scatter chart. Purpose/Benefits The shared tooltip can be used to display all 'Break by' members in a scatter chart with the s...

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

A Basic Plugin Example

If you're having trouble creating a new plugin on your own, then don't worry, It's actually quite simple!In order to create a basic plugin, which extends the functionality of a dashboard/widget, use the following basic plugin exampleBasically, a plug...

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

D3 Force Directed Network Diagram

This article explains how to create a force directed network diagram using Sisense.  This is helpful for showing hierarchies or relationship within your data.   Steps The following steps will walk through the process of adding the new chart type and...

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

Series With Only Data Points In Line Chart

To change a series within a line chart to display only the markers (data points), you can use the following code within a line chart's widget script. Just manipulate the series variable to correspond with your desired series.widget.on('processresult'...

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

Embedding Custom Visualizations Within A Widget

Introduction This document outlines the process for overriding an existing chart with a Highcharts Donut Pie chart.  For a more robust solution, it is recommended to create a custom plugin as that would allow non-technical users to create charts wi...

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

Vector Plot Plugin

DOWNLOAD LINKTraditional Vector Plot:Download Name Displayed on Vector:DownloadvectorLength (Actual Length) version:DownloadrotationOrigin (Start Point) version:DownloadPLUGIN OVERVIEWThe purpose of the plugin is to provide a visualization for vecto...

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