top of page

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





widget.on('processresult', function(se, ev){

	ev.result.yAxis[0].plotLines = [{
				color: '#2ec7b5',
				dashStyle: 'LongDash',
				width: 4,
				value: 800,
				zIndex: 5,
				label : {
					text : 'Target'
				}
            }]
})

Possible values of dashStyle are :

'Solid',

'ShortDash',

'ShortDot',

'ShortDashDot',

'ShortDashDotDot',

'Dot',

'Dash',

'LongDash',

'DashDot',

'LongDashDot',

'LongDashDotDot'



510 views2 comments

2 Kommentare

Mit 0 von 5 Sternen bewertet.
Noch keine Ratings

Rating hinzufügen
dball
12. Nov. 2024

Hi there - thanks for this website, it's a fantastic resource. Is it possible to create a dashboard script that will plot the same y-axis line (i.e. with the same value and properties) for all line charts within the dashboard? This would be super helpful for streamlining a few processes for me. Cheers!

Gefällt mir

Shnakepup
25. Sept. 2024
Mit 4 von 5 Sternen bewertet.

I was able to get this to work on Bar Charts, Column Charts, and Area Charts, but NOT Line Charts. Is there maybe a different script for Line Charts? If not, is there a particular way the Line Chart needs to be configured for the script to work correctly? Alternatively, does this script require a certain version of Sisense to work correctly (we have an older windows version)?

Gefällt mir
BI Next Level white logo

BI Next Level is your trusted resource for BI customization, data solutions, and expert insights. Explore practical tips, scripts, and tutorials for tools like Sisense, Python, and SQL. Let’s transform your data into impactful insights together.

Quick Links
Connect with us
Copyright © 2024. All Rights Reserved. Designed, Developed & Maintained  by Intertoons
bottom of page