cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar

Query Builder: disable formula column

☐ cool new feature
☐ could help many users! [disabled: Query Builder is not used very often, right?]

☑ removes something that feels like a „bug“

☐ nice to have

☐ nobody needs it

 

 

 

What inspired this wish list request? 

https://community.jmp.com/t5/Discussions/Why-is-there-such-unexpected-re-calculation-of-columns-with... 

 

 

What is the improvement you would like to see? 

Something like the options in Tables/Subset:

hogi_0-1760080713091.png

 

At least: there should be a warning message like:
you are using column formulas with reference to other rows. It's very likely that the result of this Query Builder is wrong. Please take case to disable the formulas - or remove them.

 

Why is this idea important? 

The interplay of Query Builder and Formula Columns can be toxic.
The new feature will save users from creating wrong results.
The existence of the options will help the user.

 

 

other wishes from hogi_2-1702196401638.png

 

2 Comments
hogi
Level XIII

@Sarah-Sylvestre : could you please check the status of the wish?
is the behavior considered a bug ?  no need to submit as a wish?

Sarah-Sylvestre
Level V
Status changed to: Acknowledged

This has already been reported as a bug, and I’ve added your request to it as well. For issues like this, it’s only necessary to contact Technical Support—there’s no need to submit a separate wish. That said, I know the distinction isn’t always obvious, so no worries.