cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-610066%22%20slang%3D%22en-US%22%3ERe%3A%20Summary%20Statistics%3A%20add%20Cumulative%20Probability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-610066%22%20slang%3D%22en-US%22%3E%3CP%3EAnother%20(very%20important)%20argument%20why%20it%20will%20be%20MUCH%20better%20to%20have%20this%20functionality%20directly%20implemented%20in%20Jmp%20such%20that%20no%20manual%20Transform%20columns%20are%20needed%3A%3C%2FP%3E%3CP%3EIf%20additional%20columns%20are%20used%20as%20GroupBy%2C%20Overlay%2C%20Page%26nbsp%3B%20and%20esp%3A%20Frequency%2C%20the%20official%20Graph%20Builder%20will%20automatically%20handle%20these%20informations%20correctly%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%3A%20just%20a%20tiny%20additional%20entry%20among%20al%20lthe%20others%20-and%20a%20huge%20improvement%20for%20the%20user.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-620935%22%20slang%3D%22en-US%22%3ERe%3A%20Summary%20Statistics%3A%20add%20Cumulative%20Probability%20-%20Status%20changed%20to%3A%20Acknowledged%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-620935%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20this%20suggestion%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%40hogi%3C%2FA%3E%26nbsp%3B%2C%20we%20will%20take%20this%20under%20consideration.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676153%22%20slang%3D%22en-US%22%3ERe%3A%20Summary%20Statistics%3A%20add%20Cumulative%20Probability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676153%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20noticed%20that%20there%20is%20a%20previous%20wish%20from%202022%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F12313%22%20target%3D%22_blank%22%3E%40BHarris%3C%2FA%3E%26nbsp%3B%20with%20exactly%20the%20same%20idea%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FAdd-CDFs-to-Graph-Builder%2Fm-p%2F551634%23U551634%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EAdd%20CDFs%20to%20Graph%20Builder%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20the%20other%20post%20already%20made%20it%20into%20the%20queue%20for%20a%20future%20release%2C%20this%20wish%20can%20be%20closed.%3CBR%20%2F%3E%3CBR%20%2F%3EBy%20the%20way%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4598%22%20target%3D%22_blank%22%3E%40mia_stephens%3C%2FA%3E%26nbsp%3B%2C%20future%20release%20means%20Jmp%2018%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-608623%22%20slang%3D%22en-US%22%3ESummary%20Statistics%3A%20add%20Cumulative%20Probability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-608623%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EWhat%20inspired%20this%20wish%20list%20request%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20summary%20statistics%20option%20in%20GraphBuilder%20are%20amazingly%20useful.%20I%20even%20thought%20that%20they%20enable%20the%20user%20to%20generate%20a%20grouped%20Cumulative%20Probability%20Plot%20with%20just%203%20lines%20of%20code%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fhow-to-make-cumulative-probability-plots-in-JMP%2Fm-p%2F607570%2Fhighlight%2Ftrue%23M80917%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fhow-to-make-cumulative-probability-plots-in-JMP%2Fm-p%2F607570%2Fhighlight%2Ftrue%23M80917%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%26lt%3B%26lt%3B%20Graph%20Builder(%0AVariables(%20X(%20__col1__%20)%2C%20Y(%20__col1__%20)%2COverlay(%20__groupCol__%20)%20)%2C%3CBR%20%2F%3EElements(%20Points(%20X%2C%20Y%2C%20Summary%20Statistic(%20%22Cumulative%20Percent%22%20)%20)%20))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWithout%20this%20Trick%20it's%20rather%20%22complicated%22%2C%20because%20one%20has%20to%20first%20calculate%20the%20%3CSTRONG%3ERank%20%5B%25%5D%3C%2FSTRONG%3E%20via%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fhow-to-make-cumulative-probability-plots-in-JMP%2Fm-p%2F548707%2Fhighlight%2Ftrue%23M76541%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fhow-to-make-cumulative-probability-plots-in-JMP%2Fm-p%2F548707%2Fhighlight%2Ftrue%23M76541%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ETransform%20Column(%0A%20%20%20%20%20%20%22Cumulative%20Probability%5B1%3D100%25%5D%22%2C%0A%20%20%20%20%20%20Formula(%0A%20%20%20%20%20%20%20Col%20Rank(%20Expr(%20Name%20Expr(%20As%20Column(%20var%20)%20)%20)%2C%20Expr(%20Name%20Expr(%20As%20Column(%20groupByvar%20)%20)%20)%2CExcluded()%20)%20%2F%20(%0A%20%20%20%20%20%20%20Col%20Number(%20Expr(%20Name%20Expr(%20As%20Column(%20var%20)%20)%20)%2C%20Expr(%20Name%20Expr(%20As%20Column(%20groupByvar%20)%20)%20)%2CExcluded()%20)%20%2B%201)%0A%20%20%20%20%20%20))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20my%20approach%20was%20wrong.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ECumulative%20Percent%3C%2FSTRONG%3E%20is%20%3CSTRONG%3ENOT%3C%2FSTRONG%3E%26nbsp%3B%3CEM%3E%3CSTRONG%3ECumulative%20Probability%20%5B%25%5D%3C%2FSTRONG%3E%3C%2FEM%3E%3CBR%20%2F%3Eit%20is%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126027792.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F50759iA0AF45B62D67E8BF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1678126027792.png%22%20alt%3D%22hogi_0-1678126027792.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20is%20the%20improvement%20you%20would%20like%20to%20see%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EPlease%20add%20%3CSTRONG%3ECumulative%20Probability%26nbsp%3B%3C%2FSTRONG%3Eas%20an%20option%20for%20Summary%20Statistics%20in%20Graph%20builder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhy%20is%20this%20idea%20important%3F%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20Rank%20%5B%25%5D%20will%20allow%20users%20to%20easily%20generate%20grouped%20Cumulative%20Probability%20Plots%20in%20Graph%20Builder.%3CBR%20%2F%3ECompared%20to%20the%20more%20complicated%20approach%20with%20the%20Transform%20Column%20it%20will%20have%20the%20huge%20benefit%20that%20a%20Column%20Switch%20can%20be%20used%20to%20cycle%20through%20different%20columns.%3C%2FP%3E%3CP%3ELike%20promised%20in%26nbsp%3B%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fhow-to-make-cumulative-probability-plots-in-JMP%2Fm-p%2F607570%2Fhighlight%2Ftrue%23M80917%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2Fhow-to-make-cumulative-probability-plots-in-JMP%2Fm-p%2F607570%2Fhighlight%2Ftrue%23M80917%3C%2FA%3E%3C%2FP%3E%3CP%3E...%20but%20with%20the%20correct%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1678126919567.png%22%20style%3D%22width%3A%20208px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F50760iD252FB1773701596%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1678126919567.png%22%20alt%3D%22hogi_0-1678126919567.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-608623%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EData%20Exploration%20and%20Visualization%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687257%22%20slang%3D%22en-US%22%3ERe%3A%20Summary%20Statistics%3A%20add%20Cumulative%20Probability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687257%22%20slang%3D%22en-US%22%3E%3CP%3EHm%20-%20perhaps%20keep%20both%20wishes%20open%20-%20just%20in%20case%20the%20feature%20won't%20show%20up%20in%20Jmp%2018%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Summary Statistics in Graph Builder - add Cumulative Probability

DUPLICATE of Add CDFs to Graph Builder 

 

☑ cool new feature
☑ could help many users! - especially in semiconductor industry.

☐ removes a bug

☐ nice to have

☐ nobody needs it

 

What inspired this wish list request?

Short:
hogi_0-1678126919567.png 

 

Long: 

The summary statistics option in GraphBuilder are amazingly useful. I even thought that they enable the user to generate a grouped Cumulative Probability Plot with just 3 lines of code:
https://community.jmp.com/t5/Discussions/how-to-make-cumulative-probability-plots-in-JMP/m-p/607570/... 

 

dt << Graph Builder(
Variables( X( __col1__ ), Y( __col1__ ),Overlay( __groupCol__ ) ),
Elements( Points( X, Y, Summary Statistic( "Cumulative Percent" ) ) ))

 

Without this Trick it's rather "complicated", because one has to first calculate the Rank [%] via
https://community.jmp.com/t5/Discussions/how-to-make-cumulative-probability-plots-in-JMP/m-p/548707/...

 

Transform Column(
						"Cumulative Probability[1=100%]",
						Formula(
							Col Rank( Expr( Name Expr( As Column( var ) ) ), Expr( Name Expr( As Column( groupByvar ) ) ),Excluded() ) / (
							Col Number( Expr( Name Expr( As Column( var ) ) ), Expr( Name Expr( As Column( groupByvar ) ) ),Excluded() ) + 1)
						))

 

 

Unfortunately, my approach was wrong. 

 

 

 

Cumulative Percent is NOT Cumulative Probability [%]
it is:

hogi_0-1678126027792.png

 

 

What is the improvement you would like to see? 

Please add Cumulative Probability as an option for Summary Statistics in Graph builder.

 

 

Why is this idea important? 

The Rank [%] will allow users to easily generate grouped Cumulative Probability Plots in Graph Builder.
Compared to the more complicated approach with the Transform Column it will have the huge benefit that a Column Switch can be used to cycle through different columns.

Like promised in 
https://community.jmp.com/t5/Discussions/how-to-make-cumulative-probability-plots-in-JMP/m-p/607570/...

... but with the correct result.

4 Comments
hogi
Level XI

Another (very important) argument why it will be MUCH better to have this functionality directly implemented in Jmp such that no manual Transform columns are needed:

If additional columns are used as GroupBy, Overlay, Page  and esp: Frequency, the official Graph Builder will automatically handle these informations correctly  

 

So: just a tiny additional entry among al lthe others -and a huge improvement for the user.

mia_stephens
Staff
Status changed to: Acknowledged

Thank you for this suggestion @hogi , we will take this under consideration.

hogi
Level XI

I just noticed that there is a previous wish from 2022 by @BHarris  with exactly the same idea:

Add CDFs to Graph Builder 

 

As the other post already made it into the queue for a future release, this wish can be closed.

By the way, @mia_stephens , future release means Jmp 18?

hogi
Level XI

Hm - perhaps keep both wishes open - just in case the feature won't show up in Jmp 18 ...