628618_en-US

liliconcom

Overwrite Legends

Hi JMP Community,

 

I've a jsl script that adds a number of rows to the legends in the Graph builder, but the issue is it concatenates some garbage values, if you click on the refresh legend display option it adds "0". I do not want to add 0. Any suggestions?

 

 

Names Default To Here( 1 );

dt = Current Data Table();

New Window( "",
 modal, 
 H List Box(
  Panel Box( "Assign",
   H List Box(
    Text Box( "Enter Bin Value:" ),     
    Spacer Box( size( 10, 0 ) ),
    ti = Text Edit Box( "", <<SETWIDTH>&nbsp;&nbsp;&nbsp;</SETWIDTH>

 

Automation and ScriptingRe: Overwrite Legends

It probably runs this code twice

     item1[i] << set label(
      item1[i] << Get Label || "  = " || Format(
       N Items( dt << get rows where( :Bins == item1[i] << Get Label ) ),
       "Fixed Dec",
       Use thousands separator( 1 )
      )
     );

the second time through there are no matching rows because the value changed. I've not studied it to figure out the 'right' fix, but a quick and dirty fix might be to check if the value already contains "=" and don't modify it further.