It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
Choose Language Hide Translation Bar
Level IV

data base with information from tabulate



I have a datable like this:

Database 1.jpg

the name of the last column is "Quality".


I would like to create new column in the same datatable with these informations:

Column Table( Grouping Columns( :Quality ), Statistics( Row % )  with Grouping Columns( :Product, :Year, :Month, :Week, :N° date ).


I know I can create a new table from Tabulate but I would like to have all these informations in the first data table, it will be more practical to build different graphs with only one data base.


is it possible?


thanks for your help.


best regards



Super User

Re: data base with information from tabulate

Using JSL, you can create the new columns you need, and populate them with the desired calculations you want.  You may also want to look into generating the data you want in Tabulate, and then joining the Tabulate created table back to the original table.

In either case, you will need to start learning JSL.  I suggest that you start by reading the JSL Guide

     Help==>Books==>JSL Guide

Article Labels

    There are no labels assigned to this post.