Forum Discussion

Lisha's avatar
Lisha
Cloud Apps
09-02-2022
Solved

Widget script for specific condition in Column chart

Below is a script that I had added for an indicator widget. If the secondary measure gives a result greater than 1, the widget will show NA.   widget.on('render', function (se, ev) { if(se.query...
dashboards & reporting
  • harikm007's avatar
    harikm007
    09-05-2022

    Enable 4th panel and try this script

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

	if(ev.result.series[0].data[3].y > 1)
	{
		ev.result.series = []
		ev.rawResult.values = []
	}
	
	ev.result.xAxis.categories.length = 3
	ev.result.series.length = 3
	ev.result.series[0].data.length = 3
	
})

    -Hari

Lisha's avatar
Lisha
Cloud Apps
09-05-2022

Hi,

The first way that you suggested is exactly what we are doing right now. However, that just displays a blank widget; which is not ideal for the users. Having it explicitly display N/A or 'No Result' is what I want to achieve (which is why I was hoping a widget script would be ideal)

As for the second way, it is also showing similar result as mentioned above.

Thanks

 

harikm007's avatar
harikm007
Data Warehouse
09-05-2022

Enable 4th panel and try this script

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

	if(ev.result.series[0].data[3].y > 1)
	{
		ev.result.series = []
		ev.rawResult.values = []
	}
	
	ev.result.xAxis.categories.length = 3
	ev.result.series.length = 3
	ev.result.series[0].data.length = 3
	
})

-Hari

  • Lisha's avatar
    Lisha
    Cloud Apps
    09-05-2022

    Thank you so much, Hari! Much appreciated.