top of page
Tags


Button to Show/Hide value labels
Sometime the widget looks messy when we enable value labels. At the same time it would be good to enable it to analyze the chart easily....


Button to change widget type
By default, only data designer can change the widget type. Below script will add buttons to a widget, so that user can change the widget...


Add description to Widget
Here is a method for adding detailed information about the chart and data that will always appear at the bottom of a widget. Steps:...


Add subtitle to Widget
Sometimes we may need to add some more information about the data displayed on the widget. i-button is an option to add this...


Dynamic widget title and axis label
There can be situations where we need to display widget title and axis labels based on selected item in filter. Here is a script to...


Columns chart with Fixed Placement
Here is a method to convert a column chart to fixed placement columns (Chart showing overlapping placement of columns). Steps: Create a...


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


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


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


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


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


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


Sort bar/columns/breakby manually
This script is to sort items in X-axis manually. Widget will display bar/columns in the order you specified in 'categories' list var...


Add BreakBy filter to dashboard when click on stacked chart
If a user click on a stacked chart, Sisense will add dashboard filter for the dimension in 'Categories' panel, but not for dimension in...


Enable shared tooltip in Sisense (display all 'breakby' items in tooltip)
If a 'breakby' column is added in Sisense widget, currently it shows value of one item at a time in tooltip. Here is a solution to...


Add button to Sisense widget
Below script allow you to add a button in Sisense widget and specified URL will be opened when you click on it widget.on("ready",...


Change background and font color of widgets in Sisense
Supported widget types : Line chart, Bar chart, Column chart, Pie chart, Scatter chart, Area chart widget.on('processresult',function(se,...
bottom of page