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:
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:
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.