Choose Language Hide Translation Bar
billi
Contributor

Can this be done with formula or do I need to write script?

I got this data for 3 batches with 72 runs in each batch and maximum absorption is given at time point. I want to make a chart showing what percentage of batch 1, 2 and 3 have absorption less than 10, 10-99.99,100-249.99 like this. Can this be done with a formula or do I need to write JSL for this? Data is attached and below is the table I want.

 

Absorption       % of batch 1       % of batch 2        %of batch 3

less than 10

10-99.99

100-249.99

 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Can this be done with formula or do I need to write script?

Hi,

 

This can be done with a formula column using the Conditional and Comparison functions, but there is also a great add-in for creating binning columns that can be found here (https://community.jmp.com/t5/JMP-Add-Ins/Interactive-Binning-V2/ta-p/22495).  I used that to create the bins in your data, and then used tabulate to create the table you wanted (see attached data table below).

View solution in original post

2 REPLIES 2
Highlighted

Re: Can this be done with formula or do I need to write script?

Hi,

 

This can be done with a formula column using the Conditional and Comparison functions, but there is also a great add-in for creating binning columns that can be found here (https://community.jmp.com/t5/JMP-Add-Ins/Interactive-Binning-V2/ta-p/22495).  I used that to create the bins in your data, and then used tabulate to create the table you wanted (see attached data table below).

View solution in original post

billi
Contributor

Re: Can this be done with formula or do I need to write script?

@HadleyMyers Thank you Hadley for the response. This works and this add-in is really helpful. Appreciate your help.

0 Kudos