top of page
Tags


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


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


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


Change position and color of legend items in Sisense
Sometimes we may need to move an item (or items) in legend to a specific position, for example moving 'N\A', 'Unknown', 'Not available'...


Apply different colors for each bars in Sisense
There is an in-built feature in Sisense to set colors for bars based on its values. Also its possible to set colors if there is a column...


Add target/benchmark line to a chart in Sisense
Below script allow us to plot a static target line in a chart. Supported chart types : Bar chart, Column chart, Line chart, Area chart...
bottom of page