Column Property: Inclusive/forced Values (:green_heart:)☑ cool new feature
☑ could help many users!
☑ removes something that feels like a „bug“
☐ nice to have
☐ nobody needs it
#myTop10_2024
-> JMP 19 : )
What inspired this wish list request?
short:
In Jmp it's quite complicated to generate a plot like this!
Inclusive values will fix the issue ...
long:
During the Semiconductor Lunch meeting @ Discovery Summit 2024 Europe, we found out that many of us have a similar problem:
GraphBuilder Plots with missing data.
examples:
- date with missing month, day, year ( A way to show a date with no data in graph builder )
- wafer lists with missing wafer (for 25 wafers in a 5x5 grid generated via Wrap, wafer #20 should always be at the same position, independent of how many wafers < 20 are in the data / missing)
- wafermaps with missing dies
- pass / fail
- bins with pre-defined categories (0 occurences for a specific bin)
...
Motivation via date:
at first glance, nobody will notice that the data for Tuesday is missing - there is not even a label on the axis.
To make the missing day appear, one can add a dummy row, Day of Week = Tue, all other entries of the row: missing.
... till somebody uses a data filter - then Tue is gone:
The only way to make it work: a dummy row for EVERY (!!!) item in the data filter.
And if the user has a chance to change the column for the data filter: for EVERY item in ANY column the user may pick.
Ouch !!!
What is the improvement you would like to see?
Please add a column property for inclusive values *) - values which should always show up on the axis.
For days of week: all days of the week 
For 25 "wafers" in a lot: all numbers from 1 to 25.
For pass/fail : pass and fail . Such that one day when there is a lot with 0 fails the plot will say: fails = 0. Instead of: not showing any number of fails.
Besides usage for axes, also X/Y Group & Wrap should react on the new setting. The same for Overlay and Color.
*) "inclusive"? what is the best name for the property?
- "default value" sounds like
- additional, auxiliary, supplemental suggest that the value is no actual value of the column
- after some discussion, Copilot suggested "inclusive" values - values which should be included, if missing.
Why is this idea important?
With the new column property INCLUSIVE VALUES,
- missing value information gets visible (!!!)
- the plots can be generated MUCH easier
- the generated plots are "robust" (example with Data Filter!)
other wishes from 
Data Blending and CleanupData Exploration and VisualizationRe: Default Entries for Graph BuilderI agree with this request!
Here is an example from my data where when filtering a defect type, parts with no defects disappear:
Thus I have to add in a dummy row or split the data by defect type, make missing values of the defect type columns become zeros, then restack the data. This in turn makes my file have 10-30X more rows. If I had the option to turn on a column option that forces the levels of the column to always appear with no data showing as zero that would be a big help!
Steve
Re: Default Entries for Graph BuilderBesides Axes, X/Y GRoup, Wrap, Overlay, Color etc.
also Data Filters should use the new column parameter.
At first sight, this sounds weird:
Why does it make sense to show and select a value in the Data Filter that is not in the data table?
The answer: It can be used to easily fix the current issue with:
Outlier (:alien:) screening with Jmp Dashboards - how? / Local Data Filter: option: restrict or do not restrict to current data
Re: Default Entries for Graph BuilderBesides nominal values, there should also be an option to specify the minimum range for continuous values.
At the moment, when I want to restrict a numeric value to eg weight < 100, the numeric data filter automatically creates a lower limit as well.
The disadvantage: the lower limit cannot be set arbitrarily, e.g. >0. it will automatically jump (up) to the lowest value in the data set, e.g. weight > 64.
Next time, when I open the plot again - if there is a student with weight < 64, he/she will not be shown in the plot.
With the new: default settings, one could specify a range, e.g. 0-150 or 0-70 - and prevent the data filter from automatically adjusting to the lowest value of the data table.
Re: Default Entries for Graph Builder@MarijaLind , @jpol
Re: :folded_hands: Column Property: Inclusive ValuesIf you used Map Shapes in Graph Builder - and loved the option Show missing :
This idea is closely related -- but MUCH more general!
it will work
- for continuous values on x & y axis
- for nominal values on x & y axis
- for Group X & Y
- for page
- for data filters
-- in Reports
-- in Tables/summary
It will prevent JMP
- from showing too few "values"
- from calculating wrong values
- from crashing
.. and maybe more ....
Re: :folded_hands: Column Property: Inclusive Valuesok, cool
Re: :folded_hands: Column Property: Inclusive Values - Status changed to: We like it! (in the queue)This is planned for a future version of JMP, and is currently available for testing in the JMP 19 EA, but right now it is called Forced Values property. If you are an authorized user of JMP 18 and would like to give this a try, you can join our Early Adopter program - go to jmp.com/earlyadopter. Please let us know if this fulfills your request!
Re: :folded_hands: Column Property: Inclusive ValuesHi @Sarah-Sylvestre .
It's extremely (!!!) useful. I switched most of my work to JMP19 EA to have this functionality available.
An example: with the help of Forced Values, one can use a column with formula selected() in combination with @julian 's dynamic subset - to make it extremely dynamic:
https://community.jmp.com/t5/JMP-Add-Ins/Dynamic-Subset-Add-In-Filterable-Data-Table-updated/tac-p/799313/highlight/true#M2115
The plot looks quite crowded, so let's split the plot by regions:
There is no row in the data table with State = Hawaii, so JMP doesn't know the region. This is why Hawaii shows up in all 4 regions.
... the same happens for all the other states. I was tempted to suggest an extended version of 'Forced Values', but I couldn't work out how to do it. (for values with existing entries, one could ask JMP to use those, don't invent new states in different regions - but how about Hawaii, which is missing in the data table ?!)
This example shows the limitations of Forced Values for the application "show a placeholder in the plot, even if there is no data".
The only way to produce the correct plot is via dummy rows , right?
Re: Column Property: Inclusive/forced Values (:green_heart:)forced values for continuous values - see:
https://community.jmp.com/t5/JMP-Wish-List/Column-Property-Inclusive-forced-Values/idc-p/799363/highlight/true#M6368
wow, it made it into the JMP Prioritization Survey 2025!
edit: ah, no - refers to another idea ...
see next post.
Re: Column Property: Inclusive/forced Values (:green_heart:)Ouch! Just after submitting the last post, I re-read the entry in the survey
and thought about this wish:
Graph Builder: missing data option for continuous values
which asks for something like this:
Re: Column Property: Inclusive/forced Values (:green_heart:) - Status changed to: Delivered
