topic Re: Script Question in Discussions

Script Question

Steven_Moore — Mon, 06 Nov 2017 14:42:03 GMT

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 ) )
),

Re: Script Question

txnelson — Mon, 11 Apr 2016 17:52:39 GMT

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?????

Re: Script Question

Steven_Moore — Mon, 11 Apr 2016 17:57:40 GMT

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!

Re: Script Question

jerry_cooper — Mon, 06 Nov 2017 14:43:03 GMT

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 ) )
);

Re: Script Question

Steven_Moore — Mon, 11 Apr 2016 19:19:45 GMT

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.

Re: Script Question

jerry_cooper — Mon, 06 Nov 2017 14:42:33 GMT

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 ) ) ),

Re: Script Question

Steven_Moore — Mon, 11 Apr 2016 19:32:26 GMT

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