cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-878811%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20especificadas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878811%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%C2%A1Gracias%20expertos!%3C%2FP%3E%20%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%3DOpen(%22%24SAMPLE_DATA%2FBig%20Class.jmp%22)%3B%0Aca%3D%22height1%22%3Bw%3DTry(Length(as%20Column(Current%20Data%20Table()%2Cca)%26lt%3B%0A%20%20%20%20%20%3CGET%20name%3D%22%22%3E%0A%20%20%20%20%20%200%3Bif(w%26lt%3B1%2CNew%20Column(ca))%3BColumn(ca)%26lt%3B%0A%20%20%20%20%20%20%3CFORMULA%3E%3C%2FFORMULA%3E%0A%20%20%20%20%20%3C%2FGET%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%20%20%20%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_11-43-38.png%22%20style%3D%22width%3A%20958px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F76667i20DFC76BBE459E89%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222025-06-08_11-43-38.png%22%20alt%3D%222025-06-08_11-43-38.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FCODE%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%20%3CCODE%20class%3D%22%20language-jsl%22%3E%0A%20%20%20%3CLINGO-LABS%20id%3D%22lingo-labs-878811%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%20%3CLINGO-LABEL%3EAutomatizaci%C3%B3n%20y%20scripting%3C%2FLINGO-LABEL%3E%0A%20%20%20%20%3CLINGO-LABEL%3EVentanas%3C%2FLINGO-LABEL%3E%0A%20%20%20%3C%2FLINGO-LABS%3E%3C%2FCODE%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878821%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3EPregunta%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20especificadas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878821%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3EAI%3CBR%20%2F%3E%20no%20funciona%3C%2FP%3E%20%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Current%20Data%20Table()%3B%0AcolRange%20%3D%20%7B9%2C%2010%2C%2011%7D%3B%0AminVals%20%3D%20%7B%7D%3B%0AmaxVals%20%3D%20%7B%7D%3B%0AFor(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(colRange)%2C%20i%2B%2B%2C%0A%20%20%20%20col%20%3D%20Column(dt%2C%20colRange%5Bi%5D)%3B%0A%20%20%20%20minVals%5Bi%5D%20%3D%20Col%20Min(col)%3B%0A%20%20%20%20maxVals%5Bi%5D%20%3D%20Col%20Max(col)%3B%0A)%3B%0Aget_cell_color%20%3D%20Function(%7Bcol%2C%20r%2C%20c%7D%2C%0A%20%20%20%20s%20%3D%20col%20%26lt%3B%26lt%3B%20get%20script%3B%0A%20%20%20%20p%20%3D%200%3B%0A%20%20%20%20For(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Arg(s)%2C%20i%2B%2B%2C%0A%20%20%20%20%20%20%20%20If(Head%20Name(Arg(s%2C%20i))%20%3D%3D%20%22Color%20Cells%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20p%20%3D%20i%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20Break()%3B%0A%20%20%20%20%20%20%20%20)%3B%0A%20%20%20%20)%3B%0A%20%20%20%20If(p%20!%3D%200%2C%0A%20%20%20%20%20%20%20%20L%20%3D%20Arg(Arg(s%2C%20p)%2C%201)%3B%0A%20%20%20%20%20%20%20%20color%20%3D%20%7B%7D%3B%0A%20%20%20%20%20%20%20%20For(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(L)%2C%20i%2B%2B%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20If(N%20Row(Loc(L%5Bi%5D%5B2%5D%2C%20r))%20%3D%3D%201%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20color%20%3D%20L%5Bi%5D%5B1%5D%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20Break()%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20)%3B%0A%20%20%20%20%20%20%20%20)%3B%0A%20%20%20%20%20%20%20%20Return(color)%3B%0A%20%20%20%20%2C%0A%20%20%20%20%20%20%20%20normalized%20%3D%200.5%3B%0A%20%20%20%20%20%20%20%20If(maxVals%5Bc%5D%20!%3D%20minVals%5Bc%5D%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20normalized%20%3D%20(col%5Br%5D%20-%20minVals%5Bc%5D)%20%2F%20(maxVals%5Bc%5D%20-%20minVals%5Bc%5D)%3B%0A%20%20%20%20%20%20%20%20)%3B%0A%20%20%20%20%20%20%20%20red%20%3D%20Round(255%20*%20normalized)%3B%0A%20%20%20%20%20%20%20%20green%20%3D%200%3B%0A%20%20%20%20%20%20%20%20blue%20%3D%20Round(255%20*%20(1%20-%20normalized))%3B%0A%20%20%20%20%20%20%20%20Return(RGB%20Color(red%2C%20green%2C%20blue))%3B%0A%20%20%20%20)%3B%0A)%3B%0AFor%20Each%20Row(%0A%20%20%20%20For(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(colRange)%2C%20i%2B%2B%2C%0A%20%20%20%20%20%20%20%20colIdx%20%3D%20colRange%5Bi%5D%3B%0A%20%20%20%20%20%20%20%20col%20%3D%20Column(dt%2C%20colIdx)%3B%0A%20%20%20%20%20%20%20%20Eval(Parse(Eval%20Insert(%22Column(dt%2C%20%5EcolIdx%5E)%20%26lt%3B%26lt%3B%20Color%20Cells(%7B%7Bget_cell_color(Column(dt%2C%20%5EcolIdx%5E)%2C%20Row()%2C%20%5Ei%5E)%2C%20%7BRow()%7D%7D%7D)%22)))%3B%0A%20%20%20%20)%3B%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878827%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878827%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%C2%BFEst%C3%A1s%20intentando%20colorear%20las%20celdas%20de%20una%20%3CSTRONG%3Efila%3C%2FSTRONG%3E%20usando%20un%20degradado%20de%20color%3F%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878846%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878846%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3ENo%20tengo%20una%20idea%20real%20de%20lo%20que%20se%20solicit%C3%B3%20aqu%C3%AD%2C%20pero%20aqu%C3%AD%20hay%20un%20intento%20de%20un%20script%20para%20colorear%20el%20degradado%20fila%20por%20fila.%3C%2FP%3E%20%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F*%22%22%22%20Gradient%20color%20cells%20rowwise%20(using%20whole%20data)%0A%0AAuthor%3A%20jthi%0ACreation%20Date%3A%202025-06-08%0ACreation%20JMP%20Version%3A%20JMP%20Pro%2018.2.0%0A%09%0A%22%22%22*%2F%0A%0ANames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FSAT.jmp%22)%3B%0Adt%20%26lt%3B%26lt%3B%20Delete%20Columns(%7B%22%25%20Taking%20(2004)%22%2C%20%22X%22%2C%20%22Y%22%2C%20%22Population%22%2C%20%22Latitude%22%2C%20%22Longitude%22%7D)%3B%0A%0Acont_cols%20%3D%20dt%20%26lt%3B%26lt%3B%20Get%20Column%20Names(%22Continuous%22%2C%20%22String%22)%3B%0Am%20%3D%20dt%5B0%2C%20cont_cols%5D%3B%0Amn%20%3D%20(m%20-%20Min(m))%20%2F%20(Max(m)%20-%20Min(m))%3B%0Acolors%20%3D%20Heat%20Color(mn%2C%20%22Cividis%22)%60%3B%0A%0Aidx%20%3D%200%3B%0Adt%20%26lt%3B%26lt%3B%20Begin%20Data%20Update%3B%0AFor%20Each(%7Bcontcol%7D%2C%20cont_cols%2C%0A%09For%20Each%20Row(dt%2C%0A%09%09idx%2B%2B%3B%0A%09%09Column(dt%2C%20contcol)%20%26lt%3B%26lt%3B%20Color%20Cells(colors%5Bidx%5D%2C%20Row())%3B%0A%09)%3B%0A)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20End%20Data%20Update%3B%0Await(0)%3B%0Awrite(%22%5C!NDONE%22)%3B%3C%2FCODE%3E%3C%2FPRE%3E%20%0A%20%20%20%3CDIV%20class%3D%22lia-spoiler-container%22%3E%0A%20%20%20%20%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%20target%3D%22_blank%22%3EVer%20m%C3%A1s...%3C%2FA%3E%0A%20%20%20%20%3CNOSCRIPT%3E(Resaltado%20como%20le%C3%ADdo)%3C%2FNOSCRIPT%3E%0A%20%20%20%20%3CDIV%20class%3D%22lia-spoiler-border%22%3E%0A%20%20%20%20%20%3CDIV%20class%3D%22lia-spoiler-content%22%3E%0A%20%20%20%20%20%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1749367102206.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F76678iE12AEA07940C0544%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22jthi_0-1749367102206.png%22%20alt%3D%22jthi_0-1749367102206.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%20%0A%20%20%20%20%20%20%3CBR%20%2F%3E%20%0A%20%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%20%20%3CNOSCRIPT%3E%0A%20%20%20%20%20%20%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%0A%20%20%20%20%20%20%20%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%0A%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%20%20%3C%2FNOSCRIPT%3E%0A%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%3C%2FDIV%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878847%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878847%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Current%20Data%20Table()%3B%0AcolRange%20%3D%20%7B9%2C%2010%2C%2011%7D%3B%0Acont_cols%20%3D%20%7B%7D%3B%0AFor(%20i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(%20colRange%20)%2C%20i%2B%2B%2C%0A%09Insert%20Into(%20cont_cols%2C%20Column(%20dt%2C%20colRange%5Bi%5D%20)%20%26lt%3B%26lt%3B%20Get%20Name%20)%3B%0A)%3B%0Am%20%3D%20dt%5B0%2C%20cont_cols%5D%3B%0Amn%20%3D%20(m%20-%20Min(%20m%20))%20%2F%20(Max(%20m%20)%20-%20Min(%20m%20))%3B%0Acolors%20%3D%20Heat%20Color(%20mn%2C%20%22Green%20Yellow%20Red%22%20)%3B%0Aidx%20%3D%200%3B%0Adt%20%26lt%3B%26lt%3B%20Begin%20Data%20Update%3B%0AFor%20Each(%20%7Bcontcol%7D%2C%20cont_cols%2C%0A%09For%20Each%20Row(%20dt%2C%0A%09%09idx%2B%2B%3B%0A%09%09Column(%20dt%2C%20contcol%20)%20%26lt%3B%26lt%3B%20Color%20Cells(%20colors%5Bidx%5D%2C%20Row()%20)%3B%0A%09)%3B%0A)%3B%0Adt%20%26lt%3B%26lt%3B%20End%20Data%20Update%3B%3C%2FCODE%3E%3C%2FPRE%3E%20%0A%20%20%20%3CP%20class%3D%22_tgt%20transPara%20grammarSection%22%3E%3CSPAN%20class%3D%22transSent%22%20data-group%3D%220-0%22%3EDe%20acuerdo.%3C%2FSPAN%3E%3C%2FP%3E%20%0A%20%20%20%3CP%20class%3D%22_tgt%20transPara%20grammarSection%22%3E%3CSPAN%20class%3D%22transSent%22%20data-group%3D%221-0%22%3EPero%20parece%20que%20de%20esta%20manera%20las%20tres%20columnas%20forman%20un%20todo.%3C%2FSPAN%3E%3C%2FP%3E%20%0A%20%20%20%3CP%20class%3D%22_tgt%20transPara%20grammarSection%22%3E%3CSPAN%20class%3D%22transSent%22%20data-group%3D%222-0%22%3ENo%20es%20una%20sola%20fila%20de%20tres%20celdas%20las%20que%20forman%20un%20todo%20de%20color.%3C%2FSPAN%3E%3C%2FP%3E%20%0A%20%20%20%3CP%20class%3D%22_tgt%20transPara%20grammarSection%22%3E%3CSPAN%20class%3D%22transSent%22%20data-group%3D%222-0%22%3E%C2%A1Gracias!%3C%2FSPAN%3E%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878848%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878848%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%3CSPAN%3EImplementarlo%20l%C3%ADnea%20por%20l%C3%ADnea%20ser%C3%ADa%20demasiado%20lento%3C%2FSPAN%3E%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878854%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878854%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%C2%BFQu%C3%A9%20est%C3%A1s%20intentando%20hacer%3F%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878868%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878868%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222025-06-08_22-37-05.png%22%20style%3D%22width%3A%20433px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_22-37-05.png%22%20style%3D%22width%3A%20433px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_22-37-05.png%22%20style%3D%22width%3A%20433px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_22-37-05.png%22%20style%3D%22width%3A%20433px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-08_22-37-05.png%22%20style%3D%22width%3A%20433px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F76683i277124D4C13B1EDD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222025-06-08_22-37-05.png%22%20alt%3D%222025-06-08_22-37-05.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%20%0A%20%20%20%3CP%3E%3CSPAN%3EEl%20cambio%20de%20color%20de%20cada%20fila%20se%20basa%20%C3%BAnicamente%20en%20la%20comparaci%C3%B3n%20de%20los%20valores%20en%20las%20tres%20columnas%20de%20esa%20fila.%3C%2FSPAN%3E%3C%2FP%3E%20%0A%20%20%20%3CP%3E%3CSPAN%3E%C2%A1Gracias!%3C%2FSPAN%3E%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878869%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878869%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%C2%BFTiene%20solo%20tres%20valores%20para%20cada%20fila%20y%20desea%20tener%20solo%20esos%20tres%20colores%3F%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878887%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878887%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%C2%BFAlgo%20as%C3%AD%3F%3C%2FP%3E%20%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FSAT.jmp%22)%3B%0Adt%20%26lt%3B%26lt%3B%20Delete%20Columns(%7B%22%25%20Taking%20(2004)%22%2C%20%22X%22%2C%20%22Y%22%2C%20%22Population%22%2C%20%22Latitude%22%2C%20%22Longitude%22%7D)%3B%0A%0Al%20%3D%20(dt%20%26lt%3B%26lt%3B%20Get%20Column%20Names(%22Continuous%22%2C%20%22String%22))%5B1%3A%3A3%5D%3B%0Ac1%20%3D%20%7B%22Green%22%2C%20%22Yellow%22%2C%20%22Red%22%7D%3B%0Ac2%20%3D%20%5B%5D%3B%0A%0Ac3%20%3D%20%5B%5D%3B%0AFor%20Each%20Row(dt%2C%0A%09r%20%3D%20Floor(Ranking%20Tie(dt%5BRow()%2C%20l%5D))%3B%20%2F%2F%20no%20idea%20what%20should%20be%20done%20with%20ties%0A%09c3%20%3D%20c3%20%7C%2F%20r%60%3B%0A)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Begin%20Data%20Update%3B%0AFor%20Each(%7Bi%2C%20idx%7D%2C%20l%2C%0A%09m%20%3D%20c3%5B0%2C%20idx%5D%3B%0A%09g%20%3D%20Loc(m%2C%201)%3B%0A%09y%20%3D%20Loc(m%2C%202)%3B%0A%09r%20%3D%20Loc(m%2C%203)%3B%0A%09Column(dt%2C%20i)%20%26lt%3B%26lt%3B%20Color%20Cells(%7B%7B%22Green%22%2C%20g%7D%2C%20%7B%22Yellow%22%2C%20y%7D%2C%7B%22Red%22%2C%20r%7D%7D)%3B%0A)%3B%0Adt%20%26lt%3B%26lt%3B%20End%20Data%20Update%3B%3C%2FCODE%3E%3C%2FPRE%3E%20%0A%20%20%20%3CP%3Eo%20as%C3%AD%3C%2FP%3E%20%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F*%22%22%22%20Gradient%20color%20cells%20rowwise%20(using%20whole%20data)%0A%0AAuthor%3A%20jthi%0ACreation%20Date%3A%202025-06-08%0ACreation%20JMP%20Version%3A%20JMP%20Pro%2018.2.0%0A%09%0A%22%22%22*%2F%0A%0ANames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%2FSAT.jmp%22)%3B%0Adt%20%26lt%3B%26lt%3B%20Delete%20Columns(%7B%22%25%20Taking%20(2004)%22%2C%20%22X%22%2C%20%22Y%22%2C%20%22Population%22%2C%20%22Latitude%22%2C%20%22Longitude%22%7D)%3B%0A%0Al%20%3D%20dt%20%26lt%3B%26lt%3B%20Get%20Column%20Names(%22Continuous%22%2C%20%22String%22)%3B%0Ac%20%3D%20%5B%5D%3B%0AFor%20Each%20Row(dt%2C%0A%09m%20%3D%20dt%5BRow()%2C%20l%5D%3B%0A%09mn%20%3D%20(m%20-%20Min(m))%20%2F%20(Max(m)%20-%20Min(m))%3B%0A%09c%20%3D%20c%20%7C%2F%20Heat%20Color(mn%2C%20%22Cividis%22)%3B%0A)%3B%0A%0Adt%20%26lt%3B%26lt%3B%20Begin%20Data%20Update()%3B%0AFor%20Each(%7Bi%2C%20idx%7D%2C%20l%2C%0A%09cm%20%3D%20%7B%7D%3B%0A%09For%20Each(%7Bc%2C%20idx%7D%2C%20c%5B0%2C%20idx%5D%2C%0A%09%09v%20%3D%20Eval%20List(%7Bc%2C%20Eval%20List(%7Bidx%7D)%7D)%3B%0A%09%09Insert%20Into(cm%2C%20Eval%20List(%7Bv%7D))%3B%0A%09)%3B%0A%09Eval(EvalExpr(%0A%09%09Column(dt%2C%20i)%20%26lt%3B%26lt%3B%20Color%20Cells(Expr(cm))%3B%0A%09))%3B%0A%09%0A)%3B%0Adt%20%26lt%3B%26lt%3B%20End%20Data%20Update()%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%0A%20%0A%20%20%3CLINGO-SUB%20id%3D%22lingo-sub-878927%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%C2%BFC%C3%B3mo%20establecer%20degradados%20de%20color%20para%20m%C3%BAltiples%20columnas%20espec%C3%ADficas%20trazo%20por%20trazo%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-878927%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%0A%20%20%20%3CP%3E%C2%A1Gracias%20jthi!%3CBR%20%2F%3E%20primero%3C%2FP%3E%20%0A%20%20%20%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222025-06-09_10-35-29.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-06-09_10-35-29.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F76694i5EDC789174E37D93%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222025-06-09_10-35-29.png%22%20alt%3D%222025-06-09_10-35-29.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
lala
Level IX

How to set color gradients for specified multiple columns stroke by stroke?

Thanks Experts!

dt=Open("$SAMPLE_DATA/Big Class.jmp");
ca="height1";w=Try(Length(as Column(Current Data Table(),ca)<<get name),0)>0;if(w<1,New Column(ca));Column(ca)<<Formula( height*1.1 );Current Data Table()<<run formulas;Column(ca)<<deleteFormula;

2025-06-08_11-43-38.png

10 REPLIES 10
lala
Level IX

Re: How to set color gradients for specified multiple columns stroke by stroke?

Thank jthi !
 first 

2025-06-09_10-35-29.png

Recommended Articles