cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-41237%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EDistribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41237%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EDear%20all%2C%3CBR%20%2F%3EI%C2%B4m%20sure%20its%20an%20easy%20question%20-%20so%20for%20you%20I%20think%20its%20an%20quick%20and%20easy%20answer%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Acara_con_una_leve_sonrisa%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20calculate%20the%20data%20in%20the%20distribution-overview%20based%20on%20the%20selection%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20947px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Summary.JPG%22%20style%3D%22width%3A%20947px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F6602i393EAD8B2987AF25%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Summary.JPG%22%20alt%3D%22Summary.JPG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3CBR%20%2F%3EHere%20for%20example%20I%20would%20like%20to%20see%20the%20summary%20statistics%20direct%20after%20selecting%20this%20data%20(new%20table%20calculation).%20For%20now%20I%20just%20can%20see%20this%20specific%20calculation%20if%20I%20Hide%20and%20Exclude%20the%20unneccesary%20data%20in%20the%20raw-data-table.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20this%20possible%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIm%20looking%20forward%20to%20your%20answer.%20Thanks%20alot!%3CBR%20%2F%3EFabian%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41260%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41260%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EOne%20of%20the%20great%20things%20about%20Dashboard%20Builder%20is%20that%20you%20don't%20need%20any%20programming.%20JMP%20add-ins%20also%20make%20it%20easy%20to%20disseminate%20dashboards%20to%20others.%3C%2FP%3E%0A%3CP%3EJust%20as%20an%20example%2C%20I%20made%20the%20add-in%20attached%20in%2030%20seconds%2C%20with%20no%20coding.%20If%20you%20double%20click%20on%20it%20to%20install%2C%20you%20can%20then%20go%20to%20the%20'Add-Ins'%20menu%20and%20select%20'Dashboard'%20to%20run%20it.%20It%20will%20look%20for%20file%20'Big%20Class.jmp'%2C%20which%20you%20can%20find%20in%20the%20sample%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41257%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41257%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EThe%20Dashboard%20facility%20in%20JMP%20has%20a%20template%20that%20would%20allow%20you%20to%20setup%20such%20filtering..%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BNew%3D%3D%26gt%3BDashboard%3D%3D%26gt%3BHierarchical%20Filter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41255%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41255%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESry..%26nbsp%3B%3CBR%20%2F%3EIf%20i%20run%20your%20script%20based%20on%20my%20data%2C%20%26nbsp%3BI%20get%20the%20%22Data%20Filter%20Context%20Box%22.%20If%20i%20select%20M%20I%20get%20the%20new%20graphs%20and%20as%20well%20the%20new%20calculated%20%22Summary%20statistics%22.%26nbsp%3B%3CBR%20%2F%3EThats%20excatly%20how%20i%20want%20it.%3CBR%20%2F%3EMy%20last%20question%20here%20is%3A%20How%20can%20i%20set%20up%20this%20without%20using%20the%20script%3F%20Is%20there%20a%20solution%20which%20i%20can%20select%20in%20the%20jmp-software%3F%20I%20want%20to%20explain%20my%20collegue%20to%20set%20this%20up%20without%20using%20the%20script%20(we%20don%C2%B4t%20have%20programming%20skills%20%3B-))%26nbsp%3B%3CBR%20%2F%3EDo%20you%20understand%20what%20I%20want%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20965px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%221.JPG%22%20style%3D%22width%3A%20965px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F6606i3024CDC8D254E818%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221.JPG%22%20alt%3D%221.JPG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20967px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222.JPG%22%20style%3D%22width%3A%20967px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F6607i4E5CB7D5C538F4F6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222.JPG%22%20alt%3D%222.JPG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41252%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41252%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EI%20am%20not%20understanding%20what%20you%20are%20asking.%3C%2FP%3E%0A%3CP%3E%22%3CSPAN%3E%20But%20can%20you%20show%20me%20the%20solution%20how%20i%20can%20set%20up%20this%20directly%20over%20the%20jmp%20software%3F%22%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3ECould%20you%20provide%20more%20details%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41251%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41251%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3605%22%20target%3D%22_blank%22%3E%40ian_jmp%3C%2FA%3E%20-%20thx.%20the%20local%20data%20filter%20is%20a%20good%20way%20to%20select%20the%20data!%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%40txnelson%3C%2FA%3E%20-%20I%20like%20your%20solution%20over%20the%20Data%20Filter%20Source%20Box%20as%20well..%20i%20rebuild%20your%20solution%20by%20using%20your%20script!%20But%20can%20you%20show%20me%20the%20solution%20how%20i%20can%20set%20up%20this%20directly%20over%20the%20jmp%20software%3F%20This%20would%20be%20handy%20to%20show%20this%20to%20my%20College.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41247%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41247%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EOr%20are%20you%20looking%20to%20click%20on%20the%20Male%2FFemale%20distribution%2C%20and%20for%20it%20to%20change%20the%20values%20in%20the%20other%20graphs%3C%2FP%3E%0A%3CP%3EHere%20is%20an%20example%20from%20the%20Scripting%20Index%20using%20a%20Data%20Filter%20Source%20Box%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0ANew%20Window(%20%22Selection%20Filter%22%2C%0A%20Data%20Filter%20Context%20Box(%0A%20%20H%20List%20Box(%0A%20%20%20Data%20Filter%20Source%20Box(%0A%20%20%20%20Graph%20Builder(%0A%20%20%20%20%20Size(%20208%2C%20207%20)%2C%0A%20%20%20%20%20Show%20Control%20Panel(%200%20)%2C%0A%20%20%20%20%20Show%20Legend(%200%20)%2C%0A%20%20%20%20%20Variables(%20X(%20%3Aage%20)%20)%2C%0A%20%20%20%20%20Elements(%20Bar(%20X%2C%20Legend(%203%20)%20)%20)%2C%0A%20%20%20%20%20SendToReport(%0A%20%20%20%20%20%20Dispatch(%0A%20%20%20%20%20%20%20%7B%7D%2C%0A%20%20%20%20%20%20%20%22Graph%20Builder%22%2C%0A%20%20%20%20%20%20%20OutlineBox%2C%0A%20%20%20%20%20%20%20%7BSet%20Title(%20%22Filter%22%20)%7D%0A%20%20%20%20%20%20)%0A%20%20%20%20%20)%0A%20%20%20%20)%0A%20%20%20)%2C%0A%20%20%20Platform(%0A%20%20%20%20Current%20Data%20Table()%2C%0A%20%20%20%20Bubble%20Plot(%0A%20%20%20%20%20X(%20%3Aweight%20)%2C%0A%20%20%20%20%20Y(%20%3Aheight%20)%2C%0A%20%20%20%20%20Sizes(%20%3Aage%20)%2C%0A%20%20%20%20%20Title%20Position(%200%2C%200%20)%0A%20%20%20%20)%0A%20%20%20)%0A%20%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20783px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22f1.PNG%22%20style%3D%22width%3A%20783px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F6603i9D01C92C316A7318%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22f1.PNG%22%20alt%3D%22f1.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20781px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22f2.PNG%22%20style%3D%22width%3A%20781px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F6604i837E0DEEF6C24763%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22f2.PNG%22%20alt%3D%22f2.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHere%20is%20the%20code%20adapted%20to%20the%20example%20you%20gave%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(%201%20)%3B%0Adt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0ANew%20Window(%20%22Selection%20Filter%22%2C%0A%20Data%20Filter%20Context%20Box(%0A%20%20H%20List%20Box(%0A%20%20%20Data%20Filter%20Source%20Box(%20Distribution(%20Nominal%20Distribution(%20Column(%20%3Asex%20)%20)%20)%20)%2C%0A%20%20%20Platform(%0A%20%20%20%20Current%20Data%20Table()%2C%0A%20%20%20%20Distribution(%0A%20%20%20%20%20Nominal%20Distribution(%20Column(%20%3Aage%20)%20)%2C%0A%20%20%20%20%20Continuous%20Distribution(%20Column(%20%3Aheight%20)%20)%2C%0A%20%20%20%20%20Continuous%20Distribution(%20Column(%20%3Aweight%20)%20)%0A%20%20%20%20)%0A%20%20%20)%0A%20%20)%0A%20)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22f3.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F6605iF32889D38731F68B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22f3.PNG%22%20alt%3D%22f3.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41245%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41245%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EPerhaps%20you%20can%20use%20the%20%3CA%20href%3D%22http%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2F13-1%2FLocal_Data_Filter.shtml%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Elocal%20data%20filter%3C%2FA%3E%3F%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENamesDefaultToHere(1)%3B%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0Adist%20%3D%20dt%20%26lt%3B%26lt%3B%20Distribution(%0A%20%20%20%20%20Automatic%20Recalc(%201%20)%2C%0A%20%20%20%20%20Continuous%20Distribution(%20Column(%20%3Aheight%20)%20)%2C%0A%20%20%20%20%20Continuous%20Distribution(%20Column(%20%3Aweight%20)%20)%2C%0A%20%20%20%20%20Local%20Data%20Filter(%0A%20%20%20%20%20%20Add%20Filter(%0A%20%20%20%20%20%20%20columns(%20%3Aage%2C%20%3Asex%20)%2C%0A%20%20%20%20%20%20%20Display(%20%3Aage%2C%20Size(%20160%2C%2090%20)%2C%20List%20Display%20)%0A%20%20%20%20%20%20)%0A%20%20%20%20%20)%0A%20%20%20%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EAlternatively%2C%20you%20could%20use%20a%20%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fen_gb%2Fapplications%2Fdashboard-building.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Edashboard%3C%2FA%3E%20with%20a%20selection%20filter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41242%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41242%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHey%20ron%2C%3CBR%20%2F%3EThank%20you%20for%20your%20fast%20response.%3CBR%20%2F%3EWith%20your%20solution%20I%20have%20a%20distribution%20with%20just%20the%20subset-data.%20This%20solution%20is%20the%20same%20compared%20to%20%22Hide%20and%20Exclude%22%20the%20unneccesary%20data.%3CBR%20%2F%3EWhat%20I%20am%20looking%20for%20is%20the%20same%20distribution%20overview%2C%20and%20if%20i%20select%20a%20subset%20(e.g.%20M%2FF)%20i%20want%20the%20calculated%20data%20based%20just%20on%20this%20subset.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-41241%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20Distribution%20analysis%20(e.g.%20summarize%20statistics)%20direct%20calculation%20after%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-41241%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Eperhaps%20the%20following%2C%3C%2FP%3E%0A%3CP%3Eonce%20you%20selected%20the%20subset%20go%20to%20Tables%26gt%3B%26gt%3B%26gt%3Bsubset%20and%20produce%20a%20subset%20with%20only%20the%20selected%20rows.%3C%2FP%3E%0A%3CP%3Ethen%2C%20if%20you%20open%20the%20distribution%20platform%20and%20hit%20the%20recall%20button%20you%20should%20get%20what%20you%20are%20looking%20for.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERon%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Fabian88
Level I

Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Dear all,
I´m sure its an easy question - so for you I think its an quick and easy answer :-)

I would like to calculate the data in the distribution-overview based on the selection:
Summary.JPG
Here for example I would like to see the summary statistics direct after selecting this data (new table calculation). For now I just can see this specific calculation if I Hide and Exclude the unneccesary data in the raw-data-table.

Is this possible?

Im looking forward to your answer. Thanks alot!
Fabian

2 ACCEPTED SOLUTIONS

Accepted Solutions
ian_jmp
Level X

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Perhaps you can use the local data filter?

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dist = dt << Distribution(
					Automatic Recalc( 1 ),
					Continuous Distribution( Column( :height ) ),
					Continuous Distribution( Column( :weight ) ),
					Local Data Filter(
						Add Filter(
							columns( :age, :sex ),
							Display( :age, Size( 160, 90 ), List Display )
						)
					)
				);

Alternatively, you could use a dashboard with a selection filter

View solution in original post

txnelson
Super User

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Or are you looking to click on the Male/Female distribution, and for it to change the values in the other graphs

Here is an example from the Scripting Index using a Data Filter Source Box

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Selection Filter",
	Data Filter Context Box(
		H List Box(
			Data Filter Source Box(
				Graph Builder(
					Size( 208, 207 ),
					Show Control Panel( 0 ),
					Show Legend( 0 ),
					Variables( X( :age ) ),
					Elements( Bar( X, Legend( 3 ) ) ),
					SendToReport(
						Dispatch(
							{},
							"Graph Builder",
							OutlineBox,
							{Set Title( "Filter" )}
						)
					)
				)
			),
			Platform(
				Current Data Table(),
				Bubble Plot(
					X( :weight ),
					Y( :height ),
					Sizes( :age ),
					Title Position( 0, 0 )
				)
			)
		)
	)
);

f1.PNG

f2.PNG

Here is the code adapted to the example you gave

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Selection Filter",
	Data Filter Context Box(
		H List Box(
			Data Filter Source Box( Distribution( Nominal Distribution( Column( :sex ) ) ) ),
			Platform(
				Current Data Table(),
				Distribution(
					Nominal Distribution( Column( :age ) ),
					Continuous Distribution( Column( :height ) ),
					Continuous Distribution( Column( :weight ) )
				)
			)
		)
	)
);

f3.PNG

Jim

View solution in original post

9 REPLIES 9
ron_horne
Super User (Alumni)

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

perhaps the following,

once you selected the subset go to Tables>>>subset and produce a subset with only the selected rows.

then, if you open the distribution platform and hit the recall button you should get what you are looking for.

 

Ron

 

Fabian88
Level I

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Hey ron,
Thank you for your fast response.
With your solution I have a distribution with just the subset-data. This solution is the same compared to "Hide and Exclude" the unneccesary data.
What I am looking for is the same distribution overview, and if i select a subset (e.g. M/F) i want the calculated data based just on this subset.

ian_jmp
Level X

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Perhaps you can use the local data filter?

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dist = dt << Distribution(
					Automatic Recalc( 1 ),
					Continuous Distribution( Column( :height ) ),
					Continuous Distribution( Column( :weight ) ),
					Local Data Filter(
						Add Filter(
							columns( :age, :sex ),
							Display( :age, Size( 160, 90 ), List Display )
						)
					)
				);

Alternatively, you could use a dashboard with a selection filter

txnelson
Super User

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Or are you looking to click on the Male/Female distribution, and for it to change the values in the other graphs

Here is an example from the Scripting Index using a Data Filter Source Box

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Selection Filter",
	Data Filter Context Box(
		H List Box(
			Data Filter Source Box(
				Graph Builder(
					Size( 208, 207 ),
					Show Control Panel( 0 ),
					Show Legend( 0 ),
					Variables( X( :age ) ),
					Elements( Bar( X, Legend( 3 ) ) ),
					SendToReport(
						Dispatch(
							{},
							"Graph Builder",
							OutlineBox,
							{Set Title( "Filter" )}
						)
					)
				)
			),
			Platform(
				Current Data Table(),
				Bubble Plot(
					X( :weight ),
					Y( :height ),
					Sizes( :age ),
					Title Position( 0, 0 )
				)
			)
		)
	)
);

f1.PNG

f2.PNG

Here is the code adapted to the example you gave

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Window( "Selection Filter",
	Data Filter Context Box(
		H List Box(
			Data Filter Source Box( Distribution( Nominal Distribution( Column( :sex ) ) ) ),
			Platform(
				Current Data Table(),
				Distribution(
					Nominal Distribution( Column( :age ) ),
					Continuous Distribution( Column( :height ) ),
					Continuous Distribution( Column( :weight ) )
				)
			)
		)
	)
);

f3.PNG

Jim
Fabian88
Level I

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

@ian_jmp - thx. the local data filter is a good way to select the data!
@txnelson - I like your solution over the Data Filter Source Box as well.. i rebuild your solution by using your script! But can you show me the solution how i can set up this directly over the jmp software? This would be handy to show this to my College.
txnelson
Super User

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

I am not understanding what you are asking.

" But can you show me the solution how i can set up this directly over the jmp software?"

Could you provide more details?

Jim
Fabian88
Level I

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Sry.. 
If i run your script based on my data,  I get the "Data Filter Context Box". If i select M I get the new graphs and as well the new calculated "Summary statistics". 
Thats excatly how i want it.
My last question here is: How can i set up this without using the script? Is there a solution which i can select in the jmp-software? I want to explain my collegue to set this up without using the script (we don´t have programming skills ;-)) 
Do you understand what I want? 

1.JPG2.JPG

txnelson
Super User

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

The Dashboard facility in JMP has a template that would allow you to setup such filtering..

     New==>Dashboard==>Hierarchical Filter

Jim
ian_jmp
Level X

Re: Distribution analysis (e.g. summarize statistics) direct calculation after selection?

One of the great things about Dashboard Builder is that you don't need any programming. JMP add-ins also make it easy to disseminate dashboards to others.

Just as an example, I made the add-in attached in 30 seconds, with no coding. If you double click on it to install, you can then go to the 'Add-Ins' menu and select 'Dashboard' to run it. It will look for file 'Big Class.jmp', which you can find in the sample data.

Recommended Articles