How to add two (or more) Target/Benchmark lines to a chart?

[TheLivingBubba]

Hi all!

I'm relatively new to Sisense & just finding my way. I've followed the instructions in this post about adding a Target or Benchmark line to a chart (https://www.binextlevel.com/post/add-target-benchmark-line-to-a-chart-in-sisense).

However, I've been asked to find a way to add multiple such lines to a graph, each one to be (preferably) individually configurable by line thickness, pattern, color, etc.),

I would genuinely be so thankful for anything people here can suggest.

Thank you!

[harikm007 · Accepted solution]

Hi @TheLivingBubba ,

As you see in the post, the 'ev.result.yAxis[0].plotLines' is an array. So you can add any number of plot lines to it. Here is an example:

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

	ev.result.yAxis[0].plotLines = [
			//benchmark line 1
			{
				color: '#2ec7b5',
				dashStyle: 'LongDash',
				width: 1,
				value: 800,
				zIndex: 5,
				label : {
					text : 'Target1'
				}
            },
		
			//benchmark line 2
			{
				color: 'red',
				dashStyle: 'Solid',
				width: 4,
				value: 2000,
				zIndex: 5,
				label : {
					text : 'Target2'
				}
            },
		
			//benchmark line 3
			{
				color: 'yellow',
				dashStyle: 'LongDash',
				width: 2,
				value: 4000,
				zIndex: 5,
				label : {
					text : 'Target3'
				}
            }
		]
})

And the result is:

Let me know if that works!

-Hari

https://www.binextlevel.com/ 

[harikm007 · Accepted solution]

Hi @TheLivingBubba ,

As you see in the post, the 'ev.result.yAxis[0].plotLines' is an array. So you can add any number of plot lines to it. Here is an example:

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

	ev.result.yAxis[0].plotLines = [
			//benchmark line 1
			{
				color: '#2ec7b5',
				dashStyle: 'LongDash',
				width: 1,
				value: 800,
				zIndex: 5,
				label : {
					text : 'Target1'
				}
            },
		
			//benchmark line 2
			{
				color: 'red',
				dashStyle: 'Solid',
				width: 4,
				value: 2000,
				zIndex: 5,
				label : {
					text : 'Target2'
				}
            },
		
			//benchmark line 3
			{
				color: 'yellow',
				dashStyle: 'LongDash',
				width: 2,
				value: 4000,
				zIndex: 5,
				label : {
					text : 'Target3'
				}
            }
		]
})

And the result is:

Let me know if that works!

-Hari

https://www.binextlevel.com/ 

[harikm007 · Accepted solution]

If you're looking for something fancier, you can try adding bands to the chart.

Refer: https://www.binextlevel.com/post/add-bands-to-line-chart-in-sisense 

-Hari

[TheLivingBubba]

@harikm007 - I genuinely thank you for this! So very much appreciated!