Salut tout le monde
J'essaie de faire fonctionner ma première boucle, mais je suis coincé avec un problème.
Il récupère simplement toutes les colonnes, parcourt et trace toutes les colonnes.Le problème est dans
tester == ( y_cols [ je ] ) ;
Mon intention est que test est le nom des colonnes individuelles, mais lorsque je débogue, il semble que test soit une liste de toutes les colonnes, identique à y_cols.
Ainsi, lorsque j'exécute le script, il ne trace que la première colonne, plusieurs fois.
dt = Tableau de données actuel () ;
y_cols = dt << obtenir les noms de colonnes ( chaîne ) ;
Retirer ( y_cols, 1 , 2 ) ;
nw2 = nouvelle fenêtre ( "Mon premier reportage" ) ;
pour ( je= 1 , je <=nitems ( y_cols ) , je++,
tester == ( y_cols [ je ] ) ;
go=expr ( Générateur de graphiques (
Taille ( 700 , 250 ) ,
Afficher le panneau de configuration ( 0 ) ,
Variables (
X ( :Identifiant de la pièce ) ,
Oui ( évaluer ( test ) ) ,
Recouvrir ( :Temps )
) ,
Éléments (
Points ( X, Y, Légende ( 12 ) ) ,
Doubler ( X, Y, Légende ( 14 ) , Statistique récapitulative ( "Médian" ) )
) ,
EnvoyerVersRapport (
Expédition (
{ } ,
"400",
ScaleBox,
{ Modèle de légende (
12 ,
Base ( 0 , 14 , 0 ) ,
Base ( 1 , 14 , 1 ) ,
Base ( 2 , 14 , 2 )
)}
)
)
)
) ;
nw2 << ajouter ( go ) ;
) ;
Voici une refonte mineure de votre code pour que le script fonctionne.La première partie du script crée simplement un exemple simple de table de données.
Names Default to Here( 1 );
dt = New Table( "Test of Bivariate",
Add Rows( 30 ),
New Column(
["en" => "NPN1", "ja" => "NPN1", "x-id" => "S_NPN1_Col", "zh-CN" => "NPN1"],
Numeric,
"Continuous",
Format( "Best", 10 ),
Set Property(
"Spec Limits",
{LSL( 104.412948990151 ), USL( 131.893493064355 ),
Target( 118.153221027253 ), Show Limits( 1 )}
),
Set Values(
[114.555760105678, 120.043693059459, 114.926510466106, 111.756445551183,
111.545085144313, 113.52359591958, 111.749308571209, 114.411433304976,
118.48975048042, 113.171122695149, 114.946183872216, 113.382890501824,
114.666518192776, 107.884015560041, 113.065582322339, 116.25374611217,
118.333680853156, 110.657545008855, 118.693111738676, 115.463396293845,
110.287898508744, 113.287278281031, 115.219123741957, 112.385219593504,
120.861530393886, 119.847995090729, 118.65519608864, 112.661846058518,
114.066130117341, 114.063409994947]
)
),
New Column(
["en" => "PNP1", "ja" => "PNP1", "x-id" => "S_PNP1_Col", "zh-CN" => "PNP1"],
Numeric,
"Continuous",
Format( "Best", 10 ),
Set Property(
"Spec Limits",
{LSL( 104.412948990151 ), USL( 131.893493064355 ),
Target( 118.153221027253 ), Show Limits( 1 )}
),
Set Values(
[322.616751775796, 333.128079728678, 348.978757216574, 268.548094462492,
295.073165929223, 323.833298568833, 369.320490694357, 342.987400315929,
315.52243608245, 288.978183718528, 301.607366273833, 283.191076438161,
212.800492311906, 341.443055295059, 331.555064642669, 278.646245766939,
354.677433317207, 275.259301200618, 269.055788537937, 244.936754173054,
469.298298488357, 380.107493803667, 307.351300272484, 395.390913757803,
248.385309740161, 332.715779503856, 229.971512201935, 282.355854909556,
278.876672135109, 369.802517417371]
)
),
New Column(
["en" => "PNP2", "ja" => "PNP2", "x-id" => "S_PNP2_Col", "zh-CN" => "PNP2"],
Numeric,
"Continuous",
Format( "Best", 10 ),
Set Property(
"Spec Limits",
{LSL( 104.412948990151 ), USL( 131.893493064355 ),
Target( 118.153221027253 ), Show Limits( 1 )}
),
Set Values(
[469.390289765043, 437.781112798903, 532.12814730405, 373.058628529111,
338.900737368942, 469.992171436316, 563.084459366587, 479.378108668814,
530.265608347575, 421.454501563007, 437.625180215708, 391.16014485917,
336.315923666781, 459.675297352564, 556.117457880758, 393.524854048041,
524.412197327866, 435.589457872556, 401.432160774864, 414.478191120167,
549.457336783227, 481.694954348379, 415.372316833295, 590.034261426748,
455.115879097893, 449.972226523986, 380.251466107595, 377.489216424948,
429.808729569278, 482.221726694182]
)
),
New Column(
["en" => "NPN2", "ja" => "NPN2", "x-id" => "S_NPN2_Col", "zh-CN" => "NPN2"],
Numeric,
"Continuous",
Format( "Best", 10 ),
Set Property(
"Spec Limits",
{LSL( 104.412948990151 ), USL( 131.893493064355 ),
Target( 118.153221027253 ), Show Limits( 1 )}
),
Set Values(
[115.958473043434, 120.974137316372, 117.75312418797, 114.092607737274,
113.778098130642, 116.488049497674, 115.935283026742, 115.762801088796,
116.347793739608, 116.232907922575, 115.336672965867, 117.255145685653,
118.901572658105, 110.399346473016, 117.429077171413, 117.119143668499,
114.817571362932, 113.846330724714, 117.688752124707, 117.538298327714,
112.904566955574, 116.425994464592, 115.927646041683, 114.612962021825,
116.192793106131, 119.61138824619, 115.311215206548, 115.865219100186,
115.64507142399, 114.59887334177]
)
),
New Column(
["en" => "PNP3", "ja" => "PNP3", "x-id" => "S_PNP3_Col", "zh-CN" => "PNP3"],
Numeric,
"Continuous",
Format( "Best", 10 ),
Set Property(
"Spec Limits",
{LSL( 104.412948990151 ), USL( 131.893493064355 ),
Target( 118.153221027253 ), Show Limits( 1 )}
),
Set Values(
[130.378809500886, 132.736937590235, 136.831952164704, 136.969154239163,
136.622623419893, 137.480356512481, 138.094011176166, 142.10586919757,
134.750041237898, 129.719685093372, 136.520172900026, 134.778624216716,
136.991131754497, 140.420940666186, 143.257827228986, 132.213765487819,
144.671172276421, 134.703176752174, 136.744212473486, 137.187637284245,
139.788226018039, 139.372617199359, 136.112484488985, 142.809097034809,
137.799370430979, 138.482493403385, 135.236982575217, 136.251777781494,
130.768356509183, 138.248554728086]
)
),
New Column(
["en" => "IVP1", "ja" => "IVP1", "x-id" => "S_IVP1_Col", "zh-CN" => "IVP1"],
Numeric,
"Continuous",
Format( "Best", 10 ),
Set Property(
"Spec Limits",
{LSL( 104.412948990151 ), USL( 131.893493064355 ),
Target( 118.153221027253 ), Show Limits( 1 )}
),
Set Values(
[73.4842940932646, 75.6074915248983, 73.3304733114595, 75.7647427124531,
70.5460961797334, 72.9451281758323, 75.6756511920958, 76.4874855218512,
66.4572544989587, 72.2503891181424, 68.1130267608097, 78.8045562686784,
76.4765647747647, 74.689323480678, 76.1706490573276, 75.7935715354233,
72.2088629673599, 65.6494060910306, 75.7923931517876, 77.9990166080606,
76.6172682677768, 73.7633567469775, 78.5651088817796, 69.8240361090062,
72.0636364201829, 70.7582455389162, 69.7835283880779, 72.4529462963473,
69.7646762627277, 75.321634759487]
)
),
New Column( "Date",
Numeric,
"Ordinal",
Format( "ddMonyyyy", 12 ),
Input Format( "ddMonyyyy" ),
Set Selected,
Set Values(
[3567542400, 3567628800, 3567715200, 3566678400, 3567542400, 3567888000,
3566764800, 3568665600, 3568665600, 3566937600, 3566678400, 3566419200,
3566332800, 3568060800, 3566246400, 3567715200, 3567196800, 3566505600,
3566764800, 3568233600, 3566851200, 3566505600, 3566764800, 3568665600,
3567456000, 3566246400, 3567801600, 3568492800, 3566419200, 3566160000]
)
),
New Column( "Part ID",
Numeric,
"Continuous",
Format( "Best", 12 ),
Set Values(
[1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4,
1, 2, 3, 4, 1, 2]
)
)
);
y_cols = dt << get column names( string );
y_cols = Remove( y_cols, 7, 2 );
nw2 = New Window( "My first report" );
For( i = 1, i <= N Items( y_cols ), i++,
test = y_cols[i];
gb = //Expr(
Graph Builder(
Size( 700, 250 ),
Show Control Panel( 0 ),
Variables( X( :Part id ), Y( as column( test ) ), Overlay( :Date ) ),
Elements( Points( X, Y, Legend( 12 ) ), Line( X, Y, Legend( 14 ), Summary Statistic( "Median" ) ) ),
SendToReport(
Dispatch(
{},
"400",
ScaleBox,
{Legend Model( 12, Base( 0, 14, 0 ), Base( 1, 14, 1 ), Base( 2, 14, 2 ) )}
)
)
//)
);
nw2 << append( report(gb) );
gb << close window;
);
