584907_en-US

liliconcom

Column Filters

Hello,

 

Can a feature be added to data tables to show column filters, similar to what Excel has? This would be mainly for visualization of the data. I know that this can essentially be done for analysis by using Rows -> Data Filter but that's for analysis and doesn't change the column view.

 

Regards

Mehul Shroff

Data Exploration and VisualizationRe: Column Filters - Status changed to: Acknowledged

Hi @MShroff, thank you for your suggestion! We have captured your request and will take it under consideration.

Re: Column Filters - Status changed to: Needs Info

Hi @MShroff , can you take a look at the Dynamic Subset Add-in and see if it helps you accomplish this?

Re: Column Filters

Hello @Sarah-Sylvestre,

 

Thanks, will do. However, since add-ins are not fully supported by JMP (wrt testing, debug, maintenance), my preference would be to have this be a built-in solution in JMP.

Regards

Mehul

Re: Column Filters

Hello @Sarah-Sylvestre, I downloaded the add-in and tried to install it in JMP 17. I didn't get any error messages or warnings but I didn't see it under the Add-Ins menu. I closed and restarted JMP but it still wasn't there.I tried installing it once again but got the same result. Is there a compatibility issue between this add-in and JMP 17? I recently installed another add-in and had no issues. See screenshot below.

 

 

Please kindly advise.

Regards

Mehul Shroff

Re: Column Filters

@MShroff :
The Function can be found in the Tables menu:

 

 

Re: Column Filters

Hello @hogi , @Sarah-Sylvestre ,

 

Thanks for the additional clarification. I see it now. I tried it but it didn't work the way it's shown in video at the URL provided above. I'm using this with JMP 17 and within a project in case it matters (I have frequently run into unique issues with various platforms within projects that do not occur outside projects, not sure if this is one of them). Since JMP Tech Support does not support add-ins, I'd like to reiterate my request for this to be an enhancement.

 

In case it helps, I'm happy to do a call with you to demonstrate what's going on at my end to see if I'm doing something wrong.

Regards

Mehul Shroff

Re: Column Filters

@julian 

I just checkt with Big Class opened as is and put into a project.

The behavior is indeed a bit different if the table is in a project: The Add-In starts without a data table view.
But as soon as you select a column to pick the rows to display, the table shows up and everything seems to work smoothly.
Same on your side?

 

Re: Column Filters

That's exactly right, @hogi. It's a bit of a peculiarity of the Add-In with Projects. In the 17.1 update this should be fixed without any update to the Add-In, but for now doing as you suggest is the workaround. 

Re: Column Filters - Status changed to: Investigating

Thanks for the discussion everyone! @MShroff we will still evaluate this request, as I understand having an add-in is not an ideal solution. I wanted to offer it up as a workaround until we get to prioritize this, and also I wanted to see if the add-in solved your problem to make sure I understood what you were asking for. Thank you for taking a look! 

Re: Column Filters - Status changed to: Yes, Stay Tuned!

Hello! This feature will be available in JMP 19. If you're part of the Early Adopter program, you'll likely be able to test it out in an upcoming release and share your feedback with us.

Re: Column Filters - Status changed to: Delivered