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


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
