Replace N/A values with 0 in indicators

Follow

Alina

September 06, 2016 21:01

This script replaces N/A values with 0 values. Applies for Indicator widgets.

Before:

After: 

 

Copy the following script and place it under 'Edit Script' in the designated Indicator widget:

widget.on('ready', function (w, e) {

e.widget.$noResults = false;

})

widget.on('queryend', function (w, args) {

if(!args.rawResult.values){

args.rawResult.values = [{data:0,text:"0"}]

}

})

 

 

0

• 

  Robert Vaughan June 18, 2019 14:11

  This script works great for an indicator with a single value,  when you add a secondary value is displays a blank.   Does anyone know how to handle this result i.e. when there is a secondary values on the indicator that is not null?

  1

  Comment actions Permalink
• 

  Jessica Orlando January 30, 2020 16:51

  It seems this script broke in 8.1.1 and the 0 no longer shows up, just the label of the indicator.

  0

  Comment actions Permalink
• 

  Ben Sadan February 06, 2020 23:32 (Edited February 07, 2020 20:40)

  Hi Robert Vaughan and Jessica Orlando

  replace the code you have with this, it will fix both of these problems!

  widget.on('render', function (w, q) {
  	if(w.queryResult.value.text == "")
  	{
  		w.queryResult.value.data = 0;
  		w.queryResult.value.text = 0;
  	}
  	
  	if(w.queryResult.secondary != null && w.queryResult.secondary.text == "")
  	{
  		w.queryResult.secondary.data = 0;
  		w.queryResult.secondary.text = 0;
  	}
  })

  0

  Comment actions Permalink
• 

  Jessica Orlando February 07, 2020 17:06

  Thanks Ben!

  0

  Comment actions Permalink
• 

  Brian Wilson February 11, 2020 14:47

  Thank you, Ben!

  0

  Comment actions Permalink

Please sign in to leave a comment.