I have a series of batches produced over a period of years for which a different number of samples have been taken; e.g. see Table below.
I want to be able to graphically visualise the number of batches per year but I cannot seem to be able to do that without having to build a new table in which I remove the repeats; i.e. the samples column. Is there an easy way to count and/or visualise the number of batches per year independently of the number of samples taken?
Thanks in advance for the help!
| Year | Batch | Sample | Value |
2015 | A | A1 | 2 |
| 2015 | A | A2 | 5 |
| 2016 | B | B1 | 3 |
| 2016 | C | C1 | 8 |
| 2016 | C | C2 | 1 |
| 2016 | C | C3 | 2 |
| 2016 | C | C4 | 10 |
| 2017 | D | D1 | 0 |
| 2017 | E | E1 | 5 |
| 2017 | E | E2 | 6 |
Here's a similar approach that uses the Tabulate platform.
dt = New Table( "Untitled", Add Rows( 10 ),
New Column( "Year", Numeric, "Ordinal", Format( "Best", 12 ),
Set Values( [2015, 2015, 2016, 2016, 2016, 2016, 2016, 2017, 2017, 2017] ) ),
New Column( "Batch", Character( 16 ), "Nominal",
Set Values( {"A", "A", "B", "C", "C", "C", "C", "D", "E", "E"} ) ),
New Column( "Sample", Character( 16 ), "Nominal",
Set Values( {"A1", "A2", "B1", "C1", "C2", "C3", "C4", "D1", "E1", "E2"} ) ),
New Column( "Value", Numeric, "Continuous", Format( "Best", 12 ),
Set Values( [2, 5, 3, 8, 1, 2, 10, 0, 5, 6] ) )
);
dt_tab = (dt << Tabulate(
Show Control Panel( 0 ),
Add Table( Row Table( Grouping Columns( :Year, :Batch ) ) )
)) << Make Into Data Table;
dt_tab << Graph Builder(
Show Control Panel( 0 ),
Variables( X( :Year ), Y( :N ), Overlay( :Batch ) ),
Elements( Bar( X, Y, Legend( 9 ), Bar Style( "Stacked" ) ) )
);
I am just guessing, but from your statements it sounds like you are used to doing things in Excel. The reason I am saying this, is your hesitation in creating a new data table.
"without having to build a new table in which I remove the repeats"
Using JMP, creating new data tables is a very normal process, but typically, one does not manually "remove" rows, but rather one uses one of the many JMP platforms to perform what is needed. In your case, by running the Summary Platform you can accomplish what you want very easily. And if you have thousands of rows of data, the work for you is just as simple as if you have 10s of rows.
To do this, the Summary Platform will need to be run twice.
1. Open the data table.
2. Open
Tables==>Summary
3. Fill in the dialog box to look like:
4. Click on OK and it will produce a new data table that looks like
The data in this table contains a count of the count(N Rows) of each different type of batches per year, and you want the number of batches per year. So If you run the Summary Platform on the above new data table,
You will get the following data table, which are the values you want
