Subscribe Bookmark RSS Feed

Script Question

Steven_Moore

Super User

Joined:

Jun 4, 2014

The following is part of a script I am trying to run. I want to divide my X variable before plotting. I have tried several things, but am not getting it right. Can someone help me?

Thanks!

Graph Builder(
Variables(
X( :Line 160 Cases ),
Y( :Line 160 Broke ),
Wrap( :Month ),
Color( :Month )
),
Points( X, Y, Legend( 27 ) ),
Line Of Fit( X, Y, Legend( 29 ), Confidence of Fit( 0 ), Equation( 1 ) )
),
Steve
1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Sorry, you need another closed parentheses in the X variable line (I neglected to put it there in the code that I pasted):

 

           X(  Transform Column( "My X/1000", Formula( :Line 160 Cases / 1000 ) ) ),

 

 

 

6 REPLIES
txnelson

Super User

Joined:

Jun 22, 2012

I do not understand what you are saying when you say that you want to divide your X variable?  Group it in the graph, divide it by some number, split the data into separate subsets?????

Jim
Steven_Moore

Super User

Joined:

Jun 4, 2014

Jim,  I want to divide each X value by 1000 before plotting.  I don't want to create another column and the current X column is being used in formulas for other columns already, so I don't want to have to edit all those formulas.

Thankls!

Steve
jerry_cooper

Staff

Joined:

Jul 10, 2014

Try this:

 

Graph Builder( 
     Variables(
           X(  Transform Column( "My X/1000", Formula( :Line 160 Cases / 1000 ) ),
           Y( :Line 160 Broke ),
           Wrap( :Month ),
           Color( :Month )
     ),
     Points( X, Y, Legend( 27 ) ),
     Line Of Fit( X, Y, Legend( 29 ), Confidence of Fit( 0 ), Equation( 1 ) )
);
Steven_Moore

Super User

Joined:

Jun 4, 2014

No luck:  I get an error message:  Unexpected end of input.  Perhaps there is a missing "," or ")".  Trying to parse arguments of function "Graph Builder".  Line 21 Column2:)

I typed the code exactly as you have it.  I even copied and pasted, but no luck.

Steve
Solution

Sorry, you need another closed parentheses in the X variable line (I neglected to put it there in the code that I pasted):

 

           X(  Transform Column( "My X/1000", Formula( :Line 160 Cases / 1000 ) ) ),

 

 

 

Steven_Moore

Super User

Joined:

Jun 4, 2014

Bingo!!!!  That got it.  Thanks for your help!

Steve