470683_es-ES

liliconcom

¿Por qué mi Html Interactivo (Creador de Gráficos) y Filtro Local guardados no son interactivos?

Hola experto,

Estoy casi al final de mi proyecto para el segundo lote de informes html interactivos, pero mis hermosos gráficos guardados en .html no son interactivos.

Usé una lógica similar a mi primer lote de informe html interactivo (que es automatizado e interactivo con éxito).

¿Por qué mi informe interactivo no es interactivo?

¿Qué puedo hacer para que sea interactivo? Agregué el encabezado Superior pero no funcionó.

 

//create Graph Builder
Names Default To Here( 1 );
dt3 = Data Table( "JoinT" ); 
gb = dt3 << Graph Builder(
 Size( 605, 3451 ),
 Show Control Panel( 0 ),
 Lock Scales( 1 ),
 Link Page Axes( "X and Y" ),
 Variables(
  X( :In Time ),
  Y( :Yield Exclude dummy ),
  Page( :Process Oper ),
  Overlay( :Process Mach No )
 ),
 Elements( Points( X, Y, Legend( 9 ) ) ),
 Local Data Filter(
  Add Filter(
   columns(
    Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    ),
    :Machine Type,
    :PackageFamily,
    :Machine No,
    :Recipe,
    :Process Mach No
   ),
   Display(
    Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    ),
    "Single Category Display"
   ),
   Display( :PackageFamily, "Single Category Display" ),
   Display(
    :Machine No,
    "Single Category Display",
    Find( Set Text( "" ) )
   ),
   Display( :Recipe, "Single Category Display", Find( Set Text( "" ) ) ),
   Display(
    :Process Mach No,
    "Single Category Display",
    Find( Set Text( "" ) )
   ),
   Order By Count(
    Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    )
   )
  )
 ),
 SendToReport(
  Dispatch(
   {},
   "In Time",
   ScaleBox,
   {Format( "d/m/y", 10 ), Min( 3723595037 ), Max( 3730267481.28 ),
   Interval( "Day" ), Inc( 1 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 2 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730079028.96 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 3 ),
   {Format( "d/m/y", 10 ), Min( 3723796743.08 ), Max( 3725242379.92 ),
   Interval( "Day" ), Inc( 2 ), Minor Ticks( 1 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 4 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730002981.72 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 5 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730063004.8 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 6 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730200253.12 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 7 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730020656.4 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 8 ),
   {Format( "d/m/y", 10 ), Min( 3723595299.52 ), Max( 3730267481.28 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox,
   {Format( "Fixed Dec", 15, 2 ), Min( 0 ), Max( 105 ), Inc( 10 ),
   Minor Ticks( 1 ), Add Ref Line(
    98,
    "Solid",
    "Medium Dark Red",
    "TargetYield=98.00%",
    2
   )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 2 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 13.63 ), Max( 102.111427606729 ),
   Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 3 ),
   {Format( "Fixed Dec", 15, 1 ), Min( 97.970970312416 ),
   Max( 99.8921310582744 ), Inc( 0.5 ), Minor Ticks( 1 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 4 ),
   {Format( "Fixed Dec", 15, 1 ), Min( 95.8240945419339 ),
   Max( 100.016768985686 ), Inc( 0.5 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 5 ),
   {Format( "Fixed Dec", 15, 1 ), Min( 95.8220034130674 ),
   Max( 100.057545297737 ), Inc( 0.5 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 6 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 4.52872 ), Max( 103.59928 ),
   Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 7 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 43.0752 ), Max( 101.7948 ),
   Inc( 10 ), Minor Ticks( 1 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 8 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 4.52792 ), Max( 103.62008 ),
   Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "graph title",
   TextEditBox,
   {Set Text( "AVI Yield Exclude dummy vs. In Time (Process before AVI)" )}
  )
 )
);
gb << Bring Window to Front;
//Get the container of the platform
tr = gb << Top Report;
tr << Save Interactive HTML("C:\Users\jmpuser2020c\Desktop\Manufacturing Yield Dashboard\AVI\AVIAutoReport\ProcessBeforeMCAVIYield.html");

 

secuencias de comandosRe: ¿Por qué mi Html Interactivo (Creador de Gráficos) y Filtro Local guardados no son interactivos?

Etiquetaré a una persona que sabe mucho de este tema: @John_Powell_JMP , pero lo más probable es que haya alguna característica en el gráfico/informe que (todavía) no es compatible con html interactivos.

Re: ¿Por qué mi Html interactivo (Creador de gráficos) y Filtro local guardados no son interactivos?

Hola @WebDesignesCrow ,

 

Jarmo tiene razón. Hay una característica o una combinación de condiciones en su gráfico que no son compatibles con HTML interactivo. Mirando el script y sin saber qué versión de JMP está usando, puedo hacer algunas conjeturas, pero la mejor manera de averiguarlo es mirar el resultado en el registro de JMP (Ver>Registro) después de ejecutar el script. Debería ver una o más líneas que comienzan con "HTML interactivo:"

 

Si copia estas líneas en una respuesta aquí y me informa qué versión de JMP está usando, es posible que pueda encontrar una manera de construir los gráficos de manera diferente para evitar las condiciones que hacen que los gráficos no sean interactivos.

 

~Juan

 

  

Re: ¿Por qué mi Html interactivo (Creador de gráficos) y Filtro local guardados no son interactivos?

Hola, Juan.

Gracias. Estoy usando JMP 15. Estas son las líneas de log.

//Open Seahawk & TTVision Table
dt2= Open(
 "\\domi8\Production Report\Manufacturing Yield Dashboard\AVI\AVIYield (Datasheet).xlsx",
 Worksheets( {"Seahawk"} ),
 Use for all sheets( 1 ),
 Concatenate Worksheets( 1 ),
 Create Concatenation Column( 0 ),
 Worksheet Settings(
  1,
  Has Column Headers( 1 ),
  Number of Rows in Headers( 1 ),
  Headers Start on Row( 1 ),
  Data Starts on Row( 2 ),
  Data Starts on Column( 1 ),
  Data Ends on Row( 0 ),
  Data Ends on Column( 0 ),
  Replicated Spanned Rows( 1 ),
  Replicated Spanned Headers( 0 ),
  Suppress Hidden Rows( 1 ),
  Suppress Hidden Columns( 1 ),
  Suppress Empty Columns( 1 ),
  Treat as Hierarchy( 0 ),
  Multiple Series Stack( 0 ),
  Import Cell Colors( 0 ),
  Limit Column Detect( 0 ),
  Column Separator String( "-" )
 )
);
Wait( 1);
dt2 << delete columns( [2]);
dt2 << Select Where(Is missing(:Machine Type) | Is missing(:Recipe) | is missing(:Device)) << Delete Rows;
dt2:Start Lot Time << Data Type( Numeric );
dt2:End Lot Time << Data Type( Numeric);
dt3= Open(
 "\\domi8\Production Report\Manufacturing Yield Dashboard\AVI\AVIYield (Datasheet).xlsx",
 Worksheets( {"TTVision"} ),
 Use for all sheets( 1 ),
 Concatenate Worksheets( 1 ),
 Create Concatenation Column( 0 ),
 Worksheet Settings(
  1,
  Has Column Headers( 1 ),
  Number of Rows in Headers( 1 ),
  Headers Start on Row( 1 ),
  Data Starts on Row( 2 ),
  Data Starts on Column( 1 ),
  Data Ends on Row( 0 ),
  Data Ends on Column( 0 ),
  Replicated Spanned Rows( 1 ),
  Replicated Spanned Headers( 0 ),
  Suppress Hidden Rows( 1 ),
  Suppress Hidden Columns( 1 ),
  Suppress Empty Columns( 1 ),
  Treat as Hierarchy( 0 ),
  Multiple Series Stack( 0 ),
  Import Cell Colors( 0 ),
  Limit Column Detect( 0 ),
  Column Separator String( "-" )
 )
);
Wait( 1);
dt3 << delete columns( [2]);
dt3 << Select Where(Is missing(:Machine Type) | Is missing(:Recipe) | is missing(:Device)) << Delete Rows;
//Concatenation Seahawk & TTVision Table
dt4=Data Table( "Seahawk" ) << Concatenate(
 Data Table( "TTVision" ),
 Output Table( "AVIYield (Datasheet)" )
);
Close(dt2);
Close(dt3);

//Open Data3ITDeviceListTable
dt= Open(
 "\\domi8\Production Report\Manufacturing Yield Dashboard\AVI\AVIYield (Datasheet).xlsx",
 Worksheets( "Domi3_ITDevice" ),
 Use for all sheets( 1 ),
 Concatenate Worksheets( 0 ),
 Create Concatenation Column( 0 ),
 Worksheet Settings(
  1,
  Has Column Headers( 1 ),
  Number of Rows in Headers( 1 ),
  Headers Start on Row( 1 ),
  Data Starts on Row( 2 ),
  Data Starts on Column( 1 ),
  Data Ends on Row( 0 ),
  Data Ends on Column( 0 ),
  Replicated Spanned Rows( 1 ),
  Replicated Spanned Headers( 0 ),
  Suppress Hidden Rows( 1 ),
  Suppress Hidden Columns( 1 ),
  Suppress Empty Columns( 1 ),
  Treat as Hierarchy( 0 ),
  Multiple Series Stack( 0 ),
  Import Cell Colors( 0 ),
  Limit Column Detect( 0 ),
  Column Separator String( "-" )
 )
);
:DeviceName << Set Name("Device");
//VLOOKUP Table (dt=Domi3_ITDevice) to add matching device with (dt4=AVIYield Datasheet). Add new column name Package
dt4 << update (with (dt), by matching columns (dt4:Device==dt:Device), add columns from update table(:PackageFamily));
Close(dt);
//Clean-up data
//In Recipe, recode BDD0762 DBA-xKS_V4 with BDD0762 DBA-XKS_V4
//In Recipe, recode BDD0708_DWY_MKR_V3 with BDD0708_DWY_MK_V3
//In Recipe, replace recipe string which contain " " with "_"
Names Default To Here( 1 );
dt = Data Table( "AVIYield (Datasheet)" );
dt << Begin Data Update;
dt << Recode Column(
 dt:Recipe,
 {Map Value(
  _rcOrig,
  {"BDD0762 DBA-xKS_V4", "BDD0762 DBA-XKS_V4"},
  Unmatched( _rcNow )
 )},
 Target Column( :Recipe ));
dt << End Data Update;
Names Default To Here( 1 );
dt = Data Table( "AVIYield (Datasheet)" );
dt << Begin Data Update;
dt << Recode Column(
 dt:Recipe,
 {Map Value(
  _rcOrig,
  {"BDD0708_DWY_MKR_V3", "BDD0708_DWY_MK_V3"},
  Unmatched( _rcNow )
 )},
 Target Column( :Recipe ));
Names Default To Here( 1 );
dt = Data Table( "AVIYield (Datasheet)" );
dt << Begin Data Update;
dt << Recode Column(
 dt:Recipe,
 {Substitute( _rcNow, " ", "_" )},
 Target Column( :Recipe ));
dt << End Data Update;
//Remove data with lot size <10,000 (not required for analysis)
Current Data Table() << Row Selection(
 Select where( :Total Inspected Unit < 10000 ));
r = dt << Delete Rows;
Show( r );
//Remove data with lot number does not contain ".0" (not required for analysis)
Current Data Table() << Row Selection( Select where( !Contains( :Lot No, ".0" ) ) );
r = dt << Delete Rows;
Show( r );
//Sort to Ascending Start Lot Date (Numeric)
Names Default To Here( 1 );
dt = Data Table( "AVIYield (Datasheet)" );
dt << Sort( replace table, By( :End Lot Time), Order( Ascending));
//Change Date Format (Time m/d/y h:m:s)
:End Lot Time 
<< Data Type( Numeric)
<< Format( "d/m/y h:m:s")
<< Modeling Type(continuous)
;
//set Label for Machine No, Lot No, Base Part (Device), Recipe
dt << set label columns( :Machine No, :Lot No, :Device, :Recipe );
//create group columns for Seahawk & TTV Defects
dt << group columns( "SeahawkDefects", :FBMissing Bond :: :SBBall Accuracy );
dt << group columns( "TTVDefects etc.", :Name( "NU-No Unit" ), 15 );
//open Process before AVI table
wait(1);
dt2 = Open(
   "C:\Users\jmpuser2020c\Desktop\Manufacturing Yield Dashboard\AVI\ProcessBeforeAVIMatching\Process_History_LotNoListingBeforeAVI.xlsx",
   Worksheets(
    {"2ndWirebond", "Wirebond", "2ndGlueCuring", "4thDiebond",
    "3rdDiebond", "2ndDiebond", "Diebond", "LM"}
   ),
   Use for all sheets( 1 ),
   Concatenate Worksheets( 1 ),
   Create Concatenation Column( 0 ),
   Worksheet Settings(
    1,
    Has Column Headers( 1 ),
    Number of Rows in Headers( 1 ),
    Headers Start on Row( 1 ),
    Data Starts on Row( 2 ),
    Data Starts on Column( 1 ),
    Data Ends on Row( 0 ),
    Data Ends on Column( 0 ),
    Replicated Spanned Rows( 1 ),
    Replicated Spanned Headers( 0 ),
    Suppress Hidden Rows( 1 ),
    Suppress Hidden Columns( 1 ),
    Suppress Empty Columns( 1 ),
    Treat as Hierarchy( 0 ),
    Multiple Series Stack( 0 ),
    Import Cell Colors( 0 ),
    Limit Column Detect( 0 ),
    Column Separator String( "-" )
   )
  );
wait(1);
//combine Mach No with Oven No into "Process Mach No"
dt2 << Combine Columns (
 delimiter(","), 
 Columns(
  :Mach No,
  :Oven No
  ),
 Column Name("Process Mach No")
 );
//combine Oper Desc & Cur Oper into "Process Oper"
dt2 << Combine Columns (
 delimiter(","), 
 Columns(
  :Oper Desc,
  :Cur Oper
  ),
 Column Name("Process Oper")
 );
//delete unused column
dt2 << Delete Columns ( :Oper Desc, :Cur Oper, :In Emp Name, :Out1Emp Name, :PCby, :In Qty, :Out Qty, :Yield, :Mach No, :Out2Emp Name, :In Temp, :Out Temp, :Out Emp Name, :Oven No, :Out3Emp Name, :Device );
//set Label for Lot No, Process Mach No, Process Oper
dt2 << set label columns( :Lot No, :Process Mach No, :Process Oper );
//Sort to Ascending Start Lot Date (Numeric)
Names Default To Here( 1 );
dt2 = Data Table( "Process_History_LotNoListingBeforeAVI" );
dt2 << Sort( replace table, By( :Out Time), Order( Ascending));
//join table AVI Yield Datasheet & ProcessHistory
Data Table( "Process_History_LotNoListingBeforeAVI" ) <<
Join(
 With( Data Table( "AVIYield (Datasheet)" ) ),
 SelectWith(
  :Machine Type,
  :Machine No,
  :Lot No,
  :Device,
  :Recipe,
  :Start Lot Time,
  :End Lot Time,
  :Total Inspected Unit,
  :Total Dummy Unit,
  :Total Reject Unit,
  :Overall Yield Include dummy,
  :Yield Exclude dummy,
  :FBMissing Bond,
  :FBAccuracy,
  :FBBroken Wire,
  :FBBall Size,
  :SBMissing Bond,
  :SBPlacement,
  :SBBroken Wire,
  :SBWedge Size,
  :WTDeviation,
  :WTBroken Wire,
  :Die Shift,
  :Die Surface,
  :Die Rotate,
  :Die Epoxy Insuff,
  :Die Expoxy Excess,
  :Die Substrate,
  :SBBall Missing Bond,
  :SBBall Broken Wire,
  :SBBall Accuracy,
  :Name( "NU-No Unit" ),
  :Name( "DU-Destroy Unit" ),
  :Name( "ID-Incomplete Die" ),
  :Name( "DED-Die Edge Defect" ),
  :Name( "DP-Die Placement" ),
  :Name( "EG-Excessive Glue" ),
  :Name( "IG-Insufficient Glue" ),
  :Name( "DO-Die Orientation" ),
  :Name( "NWB-No Wire Bond" ),
  :Name( "MW-Multiple Wire" ),
  :Name( "BP-Ball Placement" ),
  :Name( "DW-Distorted Wire" ),
  :Name( "IW-Incomplete Wire" ),
  :Name( "FM-Foreign Material" ),
  :Name( "MP-Missing Phosphor" ),
  :PackageFamily
 ),
 Select( :Process Oper, :Process Mach No, :In Time, :Out Time ),
 By Matching Columns( :Lot No = :Lot No ),
 Drop multiples( 0, 0 ),
 Include Nonmatches( 0, 1 ),
 Preserve main table order( 1 ),
 Output Table( "JoinT" )
);
close (dt2);
close (dt);
//create Graph Builder
Names Default To Here( 1 );
dt3 = Data Table( "JoinT" ); 
gb = dt3 << Graph Builder(
 Size( 605, 3451 ),
 Show Control Panel( 0 ),
 Lock Scales( 1 ),
 Link Page Axes( "X and Y" ),
 Variables(
  X( :In Time ),
  Y( :Yield Exclude dummy ),
  Page( :Process Oper ),
  Overlay( :Process Mach No )
 ),
 Elements( Points( X, Y, Legend( 9 ) ) ),
 Local Data Filter(
  Add Filter(
   columns(
    Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    ),
    :Machine Type,
    :PackageFamily,
    :Machine No,
    :Recipe,
    :Process Mach No
   ),
   Display(
    Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    ),
    "Single Category Display"
   ),
   Display( :PackageFamily, "Single Category Display" ),
   Display(
    :Machine No,
    "Single Category Display",
    Find( Set Text( "" ) )
   ),
   Display( :Recipe, "Single Category Display", Find( Set Text( "" ) ) ),
   Display(
    :Process Mach No,
    "Single Category Display",
    Find( Set Text( "" ) )
   ),
   Order By Count(
    Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    )
   )
  )
 ),
 SendToReport(
  Dispatch(
   {},
   "In Time",
   ScaleBox,
   {Format( "d/m/y", 10 ), Min( 3723595037 ), Max( 3730267481.28 ),
   Interval( "Day" ), Inc( 1 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 2 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730079028.96 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 3 ),
   {Format( "d/m/y", 10 ), Min( 3723796743.08 ), Max( 3725242379.92 ),
   Interval( "Day" ), Inc( 2 ), Minor Ticks( 1 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 4 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730002981.72 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 5 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730063004.8 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 6 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730200253.12 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 7 ),
   {Format( "d/m/y", 10 ), Min( 3723840000 ), Max( 3730020656.4 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "In Time",
   ScaleBox( 8 ),
   {Format( "d/m/y", 10 ), Min( 3723595299.52 ), Max( 3730267481.28 ),
   Interval( "Day" ), Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox,
   {Format( "Fixed Dec", 15, 2 ), Min( 0 ), Max( 105 ), Inc( 10 ),
   Minor Ticks( 1 ), Add Ref Line(
    98,
    "Solid",
    "Medium Dark Red",
    "TargetYield=98.00%",
    2
   )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 2 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 13.63 ), Max( 102.111427606729 ),
   Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 3 ),
   {Format( "Fixed Dec", 15, 1 ), Min( 97.970970312416 ),
   Max( 99.8921310582744 ), Inc( 0.5 ), Minor Ticks( 1 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 4 ),
   {Format( "Fixed Dec", 15, 1 ), Min( 95.8240945419339 ),
   Max( 100.016768985686 ), Inc( 0.5 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 5 ),
   {Format( "Fixed Dec", 15, 1 ), Min( 95.8220034130674 ),
   Max( 100.057545297737 ), Inc( 0.5 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 6 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 4.52872 ), Max( 103.59928 ),
   Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 7 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 43.0752 ), Max( 101.7948 ),
   Inc( 10 ), Minor Ticks( 1 )}
  ),
  Dispatch(
   {},
   "Yield Exclude dummy",
   ScaleBox( 8 ),
   {Format( "Fixed Dec", 15, 0 ), Min( 4.52792 ), Max( 103.62008 ),
   Inc( 10 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "graph title",
   TextEditBox,
   {Set Text( "AVI Yield Exclude dummy vs. In Time (Process before AVI)" )}
  )
 )
);
gb << Bring Window to Front;
//Get the container of the platform
tr = gb << Top Report;
tr << Save Interactive HTML("C:\Users\jmpuser2020c\Desktop\Manufacturing Yield Dashboard\AVI\AVIAutoReport\ProcessBeforeMCAVIYield.html");
/*Close(gb);
Close(dt3);
//set no save for auto taskscheduler
exit(nosave);

/*:
C:\Users\jmpuser2020c\Desktop\Seahawk.jmpC:\Users\jmpuser2020c\Desktop\TTVision.jmpC:\Users\jmpuser2020c\Desktop\Domi3_ITDevice.jmp
r = 555;
r = 0;C:\Users\jmpuser2020c\Desktop\Process_History_LotNoListingBeforeAVI.jmpC:\Users\jmpuser2020c\Desktop\AVIYield (Datasheet).jmp
Interactive HTML: Column "Process Mach No" has an unsupported modeling type.
Interactive HTML: Values excluded by the data filter are not exported.
Interactive HTML: Controls are not interactive.
Interactive HTML: Column "Process Mach No" has an unsupported modeling type.
Interactive HTML: Column "Process Oper" has an unsupported modeling type.
Created Web Page.

 

Re: ¿Por qué mi Html interactivo (Creador de gráficos) y Filtro local guardados no son interactivos?

Hola @WebDesignesCrow ,

 

Gracias por compartir su resultado de registro.

 

En las líneas que comienzan con "HTML interactivo:" puedo ver que hay dos columnas con tipos de modelado que no son compatibles con HTML interactivo. "Proceso Mach No" y "Proceso Oper".

Las siguientes líneas crean estas columnas combinando otras columnas:

//combine Mach No with Oven No into "Process Mach No"
dt2 << Combine Columns (
 delimiter(","), 
 Columns(
  :Mach No,
  :Oven No
  ),
 Column Name("Process Mach No")
 );
//combine Oper Desc & Cur Oper into "Process Oper"
dt2 << Combine Columns (
 delimiter(","), 
 Columns(
  :Oper Desc,
  :Cur Oper
  ),
 Column Name("Process Oper")
 );

El resultado de Combinar columnas es una columna de respuesta múltiple que es el tipo de modelado que no es compatible con HTML interactivo.

 

Puede convertir las columnas de respuesta múltiple en columnas con Tipo de datos = Carácter y Tipo de modelado = Nominal, utilizando la transformación Concat. Veo que ya ha usado esto para crear el filtro de datos locales:

Transform Column(
     "Concatenate[Process Oper]",
     Character,
     Formula( Concat( :Process Oper ) )
    ),

O, en lugar de usar Combinar columnas para crear columnas de respuesta múltiple, puede Concatenar las columnas usando un separador de coma. Sería algo como lo siguiente:

Transform Column(
    "Process Oper",
    Character,
    Formula( Char( dt2:Oper Desc ) || ", " || dt2:Cur Oper )
   )

En la fórmula, es posible que no necesite usar la función Char() si la columna Oper Desc ya es un tipo de datos de caracteres y es posible que deba agregarla para Cur Oper si la columna Cur Oper no es un tipo de datos de caracteres.

Estas son solo sugerencias. Es posible que pueda encontrar una mejor manera de evitar el uso del tipo de modelado de respuesta múltiple para los informes que desea exportar a HTML interactivo.

 

Espero que esto ayude.

~Juan

 

 

 

 

Re: ¿Por qué mi Html Interactivo (Creador de Gráficos) y Filtro Local guardados no son interactivos?

Hola, Juan,

 

Gracias por la respuesta.

De alguna manera, sigo sin poder eliminar el "tipo de modelado de respuesta múltiple".

Pensé que la forma más rápida de eliminar la "respuesta múltiple" es asignar mediante el siguiente script;

dt3 = Data Table( "JoinT" ); 
dt3:Process Mach No << data type(character) <<MODELING type=""></MODELING>

Prefiero cambiar las propiedades de las columnas después de haber combinado las tablas y las columnas.

Puedo eliminarlo manualmente, pero me gustaría usar un script para automatizar la tarea de eliminar la respuesta múltiple tanto para "Process Mach No" como para "Process Oper".

¿Alguna idea de cómo podría usar el script para eliminar la respuesta múltiple?

 

Gracias !

Re: ¿Por qué mi Html interactivo (Creador de gráficos) y Filtro local guardados no son interactivos?

Creo que este será el que quieres.

 

índice de secuencias de comandos

 

Re: ¿Por qué mi Html interactivo (Creador de gráficos) y Filtro local guardados no son interactivos?

Gracias @Craige_Hales !,

 

Probaré el método anterior también (como alternativa).

Por ahora, reviso todo el script y cambio el script anterior durante la combinación de esas dos columnas.

//combine Mach No with Oven No into "Process Mach No"
dt2 << new column ("Process Mach No", character, Formula(:Mach No || :Oven No));
dt2 << new column ("Process Oper", character, "Nominal", Formula( Char( :Cur Oper ) || "_" || :Oper Desc ));