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

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

I think it can be done in ways:

  • Add 'case statement' in Value 1, 2, 3 panels with condition 'NA measure <= 1'. For example:
    case when <Formula of NA Measure> <= 1 
then <Formula of Value 1>
else null
end​

     

  •  Enable the 4th panel in your screenshot and add below script.
    widget.on('processresult', function(se, ev){

	if(ev.result.series[0].data[3].y > 1)
	{
		ev.result.series[0].data[0].y = null
		ev.result.series[0].data[1].y = null
		ev.result.series[0].data[2].y = null
		ev.result.series[0].data[3].y = null
	}
	
	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.