// ---------------------------------------------------------------------------- // Graphen: Wissentransfer vs. Kulinarisches // ---------------------------------------------------------------------------- // Festlegung des Speicherortes Ordn = OrdnerFuerGraphen; // Modusabhängige Definitionen If( Modus == 1, // für automatisierte Graphenerzeugung TXT_Kategorie = "Trend" // Graphüberschrift , Modus == 2, // für interaktive Graphen TXT_Kategorie = "Interaktiver Graph" // Graphüberschrift ); // -------------------------------------------------- // Wissentransfer vs. Kulinarisches // -------------------------------------------------- TXT_Merkmale = "Wissenstransfer auf JMP-Veranstaltungen gewichtet mit kulinarischen Höhepunkten"; // Zeilenfilter Mastertabelle << Clear Row States << Clear select; Mastertabelle << Select Where( !Is Missing( Food_ArithmeticMean ) ); Mastertabelle << Invert Row Selection << Hide and Exclude << Clear select; // Graph erstellen gb = Mastertabelle << Graph Builder( Size( GB_Aufloesungen[1][3], GB_Aufloesungen[1][4] ), Show Control Panel( 0 ), Show Legend( 0 ), Level Underline( 1 ), Page Level Underline( 0 ), Spacing Borders( 1 ), Variables( X( Transform Column( "Custom Transform", Character, Nominal, Formula( Words( :Meeting, "_" )[1] ) ) ), Y( :Food_ArithmeticMean ), Y( :KnowHowTransfer_FoodWeighted ) ), Elements( Position( 1, 1 ), Points( X, Y, Legend( 1 ), Jitter( 0 ) ), Smoother( X, Y, Legend( 3 ) ), Caption Box( X, Y, Legend( 43 ), Summary Statistic( "N" ), X Position( "Left" ) ), Caption Box( X, Y, Legend( 44 ), Summary Statistic( "Median" ), X Position( "Right" ) ), Caption Box( X, Y, Legend( 45 ), Summary Statistic( "Mean" ), Y Position( "Bottom" ) ) ), Elements( Position( 1, 2 ), Points( X, Y, Legend( 40 ), Jitter( 0 ) ), Smoother( X, Y, Legend( 41 ) ), Caption Box( X, Y, Legend( 47 ), Summary Statistic( "N" ), X Position( "Left" ) ), Caption Box( X, Y, Legend( 48 ), Summary Statistic( "Median" ), X Position( "Right" ) ), Caption Box( X, Y, Legend( 49 ), Summary Statistic( "Mean" ), Y Position( "Bottom" ) ) ), // Elements( Position( 1, 3 ), Points( X, Y, Legend( 44 ), Jitter( 0 ) ), Smoother( X, Y, Legend( 45 ) ) ), SendToReport( Dispatch( {}, "Graph Builder", OutlineBox, {Set Title( TXT_Kategorie )} ), Dispatch( {}, "graph title", TextEditBox, {Set Text( TXT_Merkmale || " (Datenstand: " || Format( Datenstand, "d/m/y h:m:s" ) || ")" )} ), Dispatch( {}, "Custom Transform", ScaleBox, {Label Row( Set Font Size( 16 ) )} ), Dispatch( {}, "X title", TextEditBox, {Set Font Size( 16 ), Set Text( "Veranstaltungsjahr" )} ), Dispatch( {}, "Food_ArithmeticMean", ScaleBox, {Format( "Fixed Dec", 16, 2 ), Label Row( {Show Minor Grid( 1 ), Set Font Size( 20 )} )} ), Dispatch( {}, "Food_ArithmeticMean", ScaleBox, {Format( "Best", 16 ), Min( 0.9 ), Max( 1.5 ), Inc( 0.1 ), Minor Ticks( 0 ), Label Row( {Show Minor Grid( 1 ), Set Font Size( 20 )} )} ), Dispatch( {}, "KnowHowTransfer_FoodWeighted", ScaleBox, {Format( "Best", 16 ), Min( -0.1 ), Max( 1.1 ), Inc( 0.25 ), Minor Ticks( 0 ), Label Row( {Show Minor Grid( 1 ), Set Font Size( 20 )} )} ), Dispatch( {}, "Graph Builder", FrameBox, {Marker Size( 6 ), Left( 1 ), Right( 1 ), Top( 1 ), Bottom( 1 )} ), Dispatch( {}, "Graph Builder", FrameBox( 2 ), {Marker Size( 6 ), Left( 1 ), Right( 1 ), Top( 1 ), Bottom( 1 )} ), Dispatch( {}, "Y title", TextEditBox, {Set Font Size( 16 )} ), Dispatch( {}, "Y 1 title", TextEditBox, {Set Font Size( 16 )} ), Dispatch( {}, "400", ScaleBox, {Legend Model( 1, Base( 0, 0, 0 ), Properties( 0, {Line Color( 5 ), Line Width( 2 ), Marker( "FilledCircle" ), Marker Size( "XXXL" ), Fill Color( 0 )} ) ), Legend Model( 3, Properties( 0, {Line Color( 5 ), Line Width( 3 ), Marker( "FilledCircle" ), Fill Color( 0 )} ) ), Legend Model( 40, Base( 0, 0, 0 ), Properties( 0, {Line Width( 2 ), Marker( "FilledCircle" ), Marker Size( "XXXL" ), Fill Color( 0 )} ) ), Legend Model( 41, Properties( 0, {Line Width( 3 ), Fill Color( 0 )} ) )} ), Dispatch( {}, "Graph Builder", FrameBox, {Marker Size( 6 ), DispatchSeg( TextSeg( 1 ), {Font( "Segoe UI", 18, "Plain" )} )} ), Dispatch( {}, "Graph Builder", FrameBox, {Marker Size( 6 ), DispatchSeg( TextSeg( 1 ), {Font( "Segoe UI", 18, "Plain" )} ), DispatchSeg( TextSeg( 2 ), {Font( "Segoe UI", 18, "Plain" )} ), DispatchSeg( TextSeg( 3 ), {Font( "Segoe UI", 18, "Plain" )} )} ), Dispatch( {}, "Graph Builder", FrameBox( 2 ), {Marker Size( 6 ), DispatchSeg( TextSeg( 1 ), {Font( "Segoe UI", 18, "Plain" )} ), DispatchSeg( TextSeg( 2 ), {Font( "Segoe UI", 18, "Plain" )} ), DispatchSeg( TextSeg( 3 ), {Font( "Segoe UI", 18, "Plain" )} )} ) ) ); // -------------------------------------------------- // Modus 1: Datei speichern und Filter zurücksetzen // Modus 2: Graph bleibt für weitere Benutzerinteraktivität geöffnet und wird nicht abgespeichert // -------------------------------------------------- // Festlegung des Dateinamen's für Modus 1 Dateiname = "Trend_Wissenstransfer.png"; // Auswahl der Handlungsaktion nach Erstellung des Graphen in Abhängigkeit des gewählten Modus GraphBuilder_SelectActionAfterMakeGraphs( Modus );