Indicators - Conditionally format secondary value with Up / Down Arrows

Follow

Jay Dastur

August 31, 2018 16:02

Introduction

Use this script to conditionally set Up/Down arrow markers in your indicator widget.

 

 

Instructions:

Create your indicator widget and add it to the dashboard. Select the edit button and choose the Edit Script from the options menu on the top right. 

 

Add the following script and adjust the conditional logic based on your needs

 

Note: The arrows leverage the special Unicode characters in the Character Map windows utility.

 

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

 var options = {

 secondaryValue: {
 fontFamily: 'Helvetica, sans-serif',
 fontWeight: 'bold',
 color: 'grey',
 fontSizes: {
 big: 20,
 medium: 15
 }
 }
 };

 
 if(e.result.secondary.data >= 0) {
 
 e.result.secondary.text = '▲' + e.result.secondary.text;
 options.secondaryValue.color = '#00FF00';
 
 
 }
 else {
 e.result.secondary.text = '▼' + e.result.secondary.text;
 options.secondaryValue.color = '#FF0000';
 }
 
 w.indicatorInstance.setOptions('numericSimple', options);

});

2

• 

  Dhrubajyoti Das December 02, 2019 06:31

  Hi Jay,

  Thanks for sharing this piece of knowledge. Can you please tell me how can i change the color of the text of the secondary value? See below-

  

  I am talking about the text "Variance" in this case.

  1

  Comment actions Permalink
• 

  Jay Dastur December 02, 2019 15:52

  Hi Dhrubajyoti 

  You can add a secondaryTitle json object within he main Options : {} object

  secondaryTitle: {
           fontFamily: 'Helvetica, sans-serif',
           fontWeight: 'bold',
           fontSizes: {
                big: 20,
               medium: 10
           },
          color: 'blue'

  },

   

  1

  Comment actions Permalink
• 

  Denis Malenfant January 11, 2019 19:11

  When you download the dashboard as PDF the last line of the script break something and we receive an error "This shouldn't have happened..."

  

  Do you have an alternative of the following line to fix the issue?

  w.indicatorInstance.setOptions('numericSimple', options);

  0

  Comment actions Permalink
• 

  Dhrubajyoti Das December 03, 2019 05:16

  Thanks Jay. It's working fine.

  0

  Comment actions Permalink
• 

  John Randolph May 06, 2020 19:24

  This is a really great script thanks Jay! I have it working on the secondary line but, how would I implement it on an indicator widget's first or primary value. I tried removing the term "secondary", tried replacing it with "primary" and the word "values" (as that is the term used on the left panel, above secondary). None of them seemed to work. 

  Appreciate any input you might have!

  John

  0

  Comment actions Permalink
• 

  John Randolph May 11, 2020 14:11

  Here is what I was looking for. Hope it helps any future users.

  https://support.sisense.com/hc/en-us/community/posts/221227708-Adding-Conditional-Icons-to-Indicator

   

   

  0

  Comment actions Permalink
• 

  Vijay Dwivedula August 05, 2020 08:13 (Edited August 05, 2020 08:13)

  The script stopped working after 8.2.3 upgrade. Do you have a fix on the code?

  0

  Comment actions Permalink
• 

  Yurii Markov August 19, 2020 09:52

  Hey Denis Malenfant, did you find a solution for your issue? 'Cause I've got the same one. If yes, could you share it, please?

  0

  Comment actions Permalink
• 

  Denis Malenfant August 28, 2020 10:29

  Hi Yurii Markov , we are using BloX widget now to do that type of indicator

  0

  Comment actions Permalink

Please sign in to leave a comment.