Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Cumulative column sum by one continuous and one nominal variable
Created:
Jan 17, 2022 08:10 AM
| Last Modified: Jun 11, 2023 4:21 AM(1395 views)
Unfortunately, I am having issues reproducing a formula column from a Graph Builder plot. There are manufactured quantities and concentration data of individual batches in the underlying dataset. In Graph Builder, I can plot concentration data (x) vs manufactured quantities (y) and pick "Cumulative Sum" from the Summary Statistic drop down menu. This gives me an OK overview of how much material of a given concentration range was manufactured in a year. (See the attached table & table scipt therein.)
My questions
How can I recreate the y-axis using a column formula? (I have tried for a couple of hours now, but feel my cerebral capacity is insufficient to solve this. Walking around in circles:)
Is there any better way to visualize this data? I found this thread here explaining binning, but again I would have to summarize the manufactured quantities by the bins, which is something eluding me.
If I am understanding your question correctly, all you have to do, is to sort your data by concentration, and then create a new column with the following formula
Col Cumulative Sum( :"Total production, all shifts [some weight quantity]"n, :Year )
If I am understanding your question correctly, all you have to do, is to sort your data by concentration, and then create a new column with the following formula
Col Cumulative Sum( :"Total production, all shifts [some weight quantity]"n, :Year )
Re: Cumulative column sum by one continuous and one nominal variable
Created:
Jan 17, 2022 10:02 AM
| Last Modified: Jan 17, 2022 7:13 AM(1365 views)
| Posted in reply to message from txnelson 01-17-2022
Edit: OK, this is working. Thank you. I believed it was not necessary to sort the table for the By Variable. Isn't the concentration a By Variable or am I understanding this incorrectly?
Sorry for my initial answer, which is now deleted.
The Col Cumulative Sum() function accumulates row by row, for each specified By variable. Therefore you need to sort by Concentration, but not by Year. You want the values to cumulate from low concentration to high concentration. The Col Cumulative Sum() function handles the separation by Year.
