Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Re: Can this be done with formula or do I need to write script?

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 14, 2019 5:51 AM
(138 views)

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

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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).

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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).

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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