cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
doraemengs
Level III

How to categorize the same ID in row with other columns?

Hi, 

I have the data set that the same ID in multiple rows. Each rows had 1 to 3 categories. The columns represent costA to costZ that I need to stack in the same Cost column. However, I need to generate group by category 1 ( 1 if category 1 < 2000, 2 if category 1 = 2000 - 4000, 3 if category 1 = 4000 - 6000, 4 if category 1 = 6000 - 10000, 5 if category 1 > 10000). However, I need to delete category 1 that do not have category 2 or 3. In addition, category 1 to 3 do not excess 1 months (I have date column). However 1 ID can have multiple 1 to 3 categories. I try to stack it but it cannot divided group by category 1 with other category. I need to create the graph of category (x) and cost (y) by group. Anyone have any idea? please help me. Thank you! (I also attached the excel file) My JMP is version 16.

0 REPLIES 0