cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP Wish List

We want to hear your ideas for improving JMP software.

  1. Search: Please search for an existing idea first before submitting a new idea.
  2. Submit: Post your new idea using the Suggest an Idea button. Please submit one actionable idea per post rather than a single post with multiple ideas.
  3. Kudo & Comment Kudo ideas you like, and comment to add to an idea.
  4. Subscribe: Follow the status of ideas you like. Refer to status definitions to understand where an idea is in its lifecycle. (You are automatically subscribed to ideas you've submitted or commented on.)

We consider several factors when looking for what ideas to add to JMP. This includes what will have the greatest benefit to our customers based on scope, needs and current resources. Product ideas help us decide what features to work on next. Additionally, we often look to ideas for inspiration on how to add value to developments already in our pipeline or enhancements to new or existing features.

Choose Language Hide Translation Bar
0 Kudos

Call filter values in query builder only on demand

Status: New Submitted by on ‎10-29-2021 06:01 AM
1 Comment (1 New)

The current behavior of the filters in the query builder when opening a query or draging in a new filter is that all distinct values of the filter are queried automatically. When doing this on large data tables, that slows your work down significantly while you are waiting for the filter queries to finish.

I would like the possibility to tell the query builder to only start those distinct values queries manually and when I decide to, e.g., only after I have finished tweaking around with my filters or if I want to use this special filter.

1 Comment
LoveDataViz7
Level III
‎11-09-2023 12:01 PM
‎11-09-2023 12:01 PM

In the meantime, an option is to set your Preferences to default to a Manual list (where you type in the filter options) - see image 1.  I have mine set up this way because of many large tables that take forever to populate the list of options.  Also, once you have selected the filter items in the List Box method of filtering, you can convert the filter to Manual, and it will populate with the items you had selected - see image 2.  I find this very useful as the lists are usually very long and it is much easier to see the options in a short list vs lots of scrolling to see what is highlighted.  If you regularly need to see the updated list of options, this won't work, but they might be helpful in the interim.  You can switch back and forth between Manual List and List Box filtering anytime, and your selections are saved and converted between the two visualizations.

LoveDataViz7_0-1699545688327.png  

LoveDataViz7_1-1699546141824.png