☑ cool new feature
☑ could help many users!
☑ removes something that feels like a “bug”
☐ nice to have
☐ nobody needs it What inspired this wish list request?
Binning continuous data in JMP typically creates an additional formula column. For tables with many measurement columns, this leads to many additional columns for information that logically belongs to the original columns. A common example is classifying measurements as Pass/Fail or Below Spec/In Spec/Above Spec. The raw values, specification limits, and derived classes are closely related, but JMP currently stores them separately.
What is the improvement you would like to see? Allow a binning definition to be stored as a Column Property of the original column. The column would retain its continuous values while also providing a dynamically derived binned representation, without creating new columns. JMP platforms could let users switch between Raw Values and Binned Values or use both representations in different roles, for example raw values on Y and bins as Color. Presets could include Pass/Fail, Below Spec/In Spec/Above Spec using the column’s existing Spec Limits, quantiles, and custom bins. Just have a look @ @Jeff_Perkinson 's Custom Binning Tool. With the new implementation, we can use the same tool, but the settings are linked to the source column - and the results are stored with the source column. - No hiccups when merging tables! - Changes to the binning definition or Spec Limits will automatically update dependent analyses.
A logical future extension would be support for multiple named binning definitions that can be switched when needed.
Why is this idea important?
Embedded binning would prevent column proliferation, keep the classification logic inherently connected to its source data, and eliminate ambiguity about which derived column belongs to which measurement. It would make it easier to switch plots between continuous and categorical views, calculate yield directly, apply consistent colors and ordering, and maintain analyses when limits or binning rules change.
Just imagine how useful the new approach will be in combination with Column Switcher!
AI likes the idea:
... View more