top of page
Tags


Hide widgets from a dashboard
Here is a script to hide one or widgets from a dashboard. (Its possible to modify the script so that a widget can be hide/unhide based on...


Display values in legend - Pie chart
The script below displays value of each items along with legend Steps: Create a pie chart Add below script to widget Save the script and...


Display total value in legend - Bar/Column/Area/Line chart
A column chart splits the data by one or more dimensions and we have to manually sum up or create a separate widget to find total value...


Convert bar chart to progress bars
Below script to allow us convert a bar chart to progress bars. Steps: Create a bar chart Bar chart should contains only one field under...


Add background image to a widget
Below script allow us to add background image to a widget. Steps: Create a widget. (supported widget types : bar, column, area, line,...


Transparent bar/column chart
We can control the transparency of bar or column chart using below script Steps: Create bar/column chart Add below script to chart Save...


Gradient fill in Scatter chart
Gradient colors can be applied to a scatter chart using below script Steps: Create a scatter chart Add below script to widget Save script...


Format data labels
Here is a script to format data labels of widgets. Supported widget types : Line chart, Bar chart, Column chart, Area chart Steps:...


Set marker symbol for each category in line chart
Different marker symbols can be set to line chart based on its value (Y-axis) using this script. But in some cases we may need to set...


Additional columns in CSV
When we export a widget as CSV, it just contains the widget's dimensions and measures. Additional measure columns that are not part of...


Add Data label to center of donut chart
Below script will display total value at the center of donut chart. Steps: Create a donut chart Add below script to the widget. Update...


Gradient color in pie chart
Below script will add gradient color to pie chart. Steps: Create pie chart Add below widget script and update the variable 'color1' with...


Gradient color in bar/column/line/area chart
Below script will add gradient color to widget. Supported widget types are bar chart, column chart, line chart and area chart Steps:...


Replace X-axis labels in a widget
We sometimes need to rename X-Axis labels to make them more meaningful. For example, if we have month numbers in a database, we can...


Always display value labels outside column/bar
Value labels may occasionally overlap with column/bar labels. Changing the max value of yAxis is a simple technique to display value...


Formatting Tabber
Most of the Sisense users are aware of and using Tabber plugin. By default, it comes with some basic styles like color, height etc....


Add additional information to tooltip - Area map
By default, in Area Map, tooltip shows limited information like name of country/state and one calculated value. Below script allow us to...


Add pagination to Bar/Column chart
If a widget contain large number of bars/columns, it may be difficult to analyze the chart. In such case one option is to enable Auto...


Convert pie chart to semi-circle donut
A pie chart can be converted to semi circle donut using below script. widget.on('processresult', function(se, ev){...


Line chart with image/icon markers
Its possible to set different shapes and icons as marker inline chart. Here is script to set different types of markers based on...
bottom of page