cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
%3CLINGO-SUB%20id%3D%22lingo-sub-826741%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3EUtilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826741%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1736536615203.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71826i25F2D784E93F060A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_2-1736536615203.png%22%20alt%3D%22hogi_2-1736536615203.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%3CP%3E...%20il%20semble%20que%20ce%20ne%20soit%20plus%20possible%20%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736574848597.png%22%20style%3D%22width%3A%20377px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71845iE44B4D6E2F66EA1E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1736574848597.png%22%20alt%3D%22hogi_0-1736574848597.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%3CP%3Etest%C3%A9%20avec%20JMP18.1.1%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EJMP17%26nbsp%3B%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_3-1736536719759.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71827i3F73419D43BFF8FA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_3-1736536719759.png%22%20alt%3D%22hogi_3-1736536719759.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%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826741%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CLINGO-LABEL%3EAutomatisation%20et%20scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826824%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Utilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826824%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ESemble%20fonctionner%20correctement%20dans%20toutes%20les%20versions%20que%20j'ai%20essay%C3%A9es%2C%20y%20compris%20la%2018.1.1.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222025-01-10_17-05-01.034.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71844i78330B944538DAF7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%222025-01-10_17-05-01.034.png%22%20alt%3D%222025-01-10_17-05-01.034.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%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826827%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Utilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826827%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EOK%20bien.%3CBR%20%2F%3E%3CBR%20%2F%3E%20Et%20c'est%20un%20peu%20%C3%A9trange...%3C%2FP%3E%3CP%3EDonc%2C%20ce%20n'est%20ni%20100%20%25%20r%C3%A9par%C3%A9%2C%20ni%20100%20%25%20fonctionnel.%3CBR%20%2F%3E%20qu'est%20ce%20qui%20fait%20la%20diff%C3%A9rence%20%3F%3C%2FP%3E%3CP%3EPC%20ou%20Mac%20%3F%3CBR%20%2F%3E%20...%20Je%20vais%20v%C3%A9rifier%20mes%20pr%C3%A9f%C3%A9rences%20-%20et%20comparer%20avec%20plus%20de%20coll%C3%A8gues.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826832%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Utilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826832%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3ELa%20bonne%20chose%20%3A%3CBR%20%2F%3E%20Ce%20n'est%20pas%20un%20probl%C3%A8me%20g%C3%A9n%C3%A9ral%20de%20%C2%AB%20d%C3%A9calage%20%C2%BB%3CBR%20%2F%3E%3CBR%20%2F%3E%20...%20cela%20semble%20%C3%AAtre%20caus%C3%A9%20par%20%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736578008881.png%22%20style%3D%22width%3A%20375px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71847i7A26B39C512ED097%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_1-1736578008881.png%22%20alt%3D%22hogi_1-1736578008881.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3ELorsque%20je%20g%C3%A9n%C3%A8re%20la%20formule%20de%20cette%20fa%C3%A7on%2C%20les%20entr%C3%A9es%20sont%20vides.%3CBR%20%2F%3E%20Lorsque%20je%20cr%C3%A9e%20une%20nouvelle%20colonne%20et%20que%20j'ajoute%20la%20formule%20par%20la%20suite%2C%20les%20valeurs%20sont%20calcul%C3%A9es.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CSTRONG%3Eajout%C3%A9%20%3A%3C%2FSTRONG%3E%20vid%C3%A9o%20avec%20diff%C3%A9rentes%20mani%C3%A8res%20de%20g%C3%A9n%C3%A9rer%20la%20colonne%20de%20formules%3C%2FP%3E%3COL%3E%3CLI%3Enouvelle%20colonne%20de%20formule%20%3A%20ajouter%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3Eun%20d%C3%A9calage%3C%2FFONT%3E%20via%20un%20clic%20-%26gt%3B%20%3CSTRONG%3E%C3%A9chouer%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Enouvelle%20colonne%20de%20formule%20%3A%20ajouter%20%3CFONT%20face%3D%22courier%20new%2Ccourier%22%3Eun%20d%C3%A9calage%3C%2FFONT%3E%20manuellement%20-%26gt%3B%20%3CSTRONG%3E%C3%A9chec%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Enouvelle%20colonne%20de%20formule%20%3A%20supprimer%20le%20code%20et%20r%C3%A9%C3%A9crire%20-%26gt%3B%20%3CSTRONG%3E%C3%A9chec%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3Enouvelle%20colonne%20-%26gt%3B%20ajouter%20la%20formule%20manuellement%20-%26gt%3B%20fonctionne%3C%2FLI%3E%3CLI%3Enouvelle%20colonne%20-%26gt%3B%20ajouter%20une%20colonne%20de%20formule%20via%20cliquer%20et%20%C3%A9crire%20(comme%20%232)%20-%26gt%3B%20fonctionne%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-vid-container%20video-embed-center%22%3E%3CDIV%20id%3D%22lia-vid-6366947406112w770h540r158%22%20class%3D%22lia-video-brightcove-player-container%22%3E%3CVIDEO-JS%20data-video-id%3D%226366947406112%22%20data-account%3D%226058004218001%22%20data-player%3D%22default%22%20data-embed%3D%22default%22%20class%3D%22vjs-fluid%22%20controls%3D%22%22%20data-application-id%3D%22%22%20style%3D%22width%3A%20100%25%3B%20height%3A%20100%25%3B%22%3E%3C%2FVIDEO-JS%3E%3C%2FDIV%3E%3CSCRIPT%20src%3D%22https%3A%2F%2Fplayers.brightcove.net%2F6058004218001%2Fdefault_default%2Findex.min.js%22%3E%3C%2FSCRIPT%3E%3CA%20class%3D%22video-embed-link%22%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fvideo%2Fgallerypage%2Fvideo-id%2F6366947406112%22%20target%3D%22_blank%22%3E(voir%20dans%20Mes%20vid%C3%A9os)%3C%2FA%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826833%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%20%3A%20Utilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826833%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJ'ai%20envoy%C3%A9%20un%20ticket%20au%20support%20JMP%20%3A%20TS-00182750%3CBR%20%2F%3E%20Voyons%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826834%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Utilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826834%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EIl%20semble%20que%20JMP%20%C3%A9value%20de%20mani%C3%A8re%20incorrecte%20l'argument%20%C2%AB%20manquant%20%C2%BB%20de%20Empty()%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20Transform%20column%0AData%20Table(%22Big%20Class%22)%20%26lt%3B%26lt%3B%20Apply%20Formula(%0A%09Columns(%3Aweight)%2C%0A%09Formula(Lag(%3Aweight%2C%20Empty()))%2C%0A%09Output(New%20Formula)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3ESi%20vous%20utilisez%20Lag%20sous%20Row%2C%20cela%20ne%20se%20produit%20pas%20car%20il%20utilise%20une%20autre%20m%C3%A9thode%20pour%20cr%C3%A9er%20la%20colonne%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20New%20formula%20column%3A%20Lag%5Bweight%5D%0AData%20Table(%22Big%20Class%22)%20%26lt%3B%26lt%3B%20New%20Formula%20Column(%0A%09Operation(Category(%22Row%22)%2C%20%22Lag%22)%2C%0A%09Columns(%3Aweight)%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CBR%20%2F%3E%0A%3CP%3EEdit%20%3A%20Et%20cela%20arrive%20aussi%20avec%20d'autres%20fonctions%20(au%20moins%20avec%20Dif%20mais%20il%20pourrait%20y%20en%20avoir%20d'autres)%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2F%20Transform%20column%0AData%20Table(%22Big%20Class%22)%20%26lt%3B%26lt%3B%20Apply%20Formula(%0A%09Columns(%3Aweight)%2C%0A%09Formula(Dif(%3Aweight%2C%20Empty()))%2C%0A%09Output(New%20Formula)%0A)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826836%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERe%20%3A%20Utilisez-vous%20lag(x)%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826836%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3EBonne%20remarque%2C%20merci%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthi%3C%2FA%3E%20d'avoir%20creus%C3%A9%20plus%20profond%C3%A9ment.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EJe%20n'ai%20jamais%20fait%20attention%20et%20j'ai%20remarqu%C3%A9%20les%202%20fa%C3%A7ons%20dont%20l'%C3%A9diteur%20de%20formule%20affiche%20les%20arguments%20facultatifs%26nbsp%3B%3A%3C%2FP%3E%3COL%3E%3CLI%3Eexplicite%3A%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_1-1736585128111.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736585128111.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_1-1736585128111.png%22%20style%3D%22width%3A%20243px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71850iAFEAB20DAA52F1A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_1-1736585128111.png%22%20alt%3D%22hogi_1-1736585128111.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3Epas%20%5Bjuste%20dans%20la%20description%5D%20%3A%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_0-1736585047899.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736585047899.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_0-1736585047899.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71849iBA2E0F5F1DAEE79D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22hogi_0-1736585047899.png%22%20alt%3D%22hogi_0-1736585047899.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
View Original Published Thread

Utilisez-vous lag(x) ?

hogi
Level XII

undefined

... il semble que ce ne soit plus possible :

undefined

testé avec JMP18.1.1


JMP17 :

undefined


Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

2 ACCEPTED SOLUTIONS

Accepted Solutions
hogi
Level XII

Re : Utilisez-vous lag(x) ?

La bonne chose :
Ce n'est pas un problème général de « décalage »

... cela semble être causé par :

undefined


Lorsque je génère la formule de cette façon, les entrées sont vides.
Lorsque je crée une nouvelle colonne et que j'ajoute la formule par la suite, les valeurs sont calculées.


ajouté : vidéo avec différentes manières de générer la colonne de formules

  1. nouvelle colonne de formule : ajouter un décalage via un clic -> échouer
  2. nouvelle colonne de formule : ajouter un décalage manuellement -> échec
  3. nouvelle colonne de formule : supprimer le code et réécrire -> échec
  4. nouvelle colonne -> ajouter la formule manuellement -> fonctionne
  5. nouvelle colonne -> ajouter une colonne de formule via cliquer et écrire (comme #2) -> fonctionne

Video Player is loading.
Current Time 0:00
Duration 0:00
Loaded: 0%
Stream Type LIVE
Remaining Time 0:00
 
1x
    • Chapters
    • descriptions off, selected
    • captions off, selected



      jthi
      Super User

      Re : Utilisez-vous lag(x) ?

      Il semble que JMP évalue de manière incorrecte l'argument « manquant » de Empty()

      // Transform column
      Data Table("Big Class") << Apply Formula(
      	Columns(:weight),
      	Formula(Lag(:weight, Empty())),
      	Output(New Formula)
      );

      Si vous utilisez Lag sous Row, cela ne se produit pas car il utilise une autre méthode pour créer la colonne

      // New formula column: Lag[weight]
      Data Table("Big Class") << New Formula Column(
      	Operation(Category("Row"), "Lag"),
      	Columns(:weight)
      );

      Edit : Et cela arrive aussi avec d'autres fonctions (au moins avec Dif mais il pourrait y en avoir d'autres)

      // Transform column
      Data Table("Big Class") << Apply Formula(
      	Columns(:weight),
      	Formula(Dif(:weight, Empty())),
      	Output(New Formula)
      );
      
      6 REPLIES 6
      Jeff_Perkinson
      Community Manager Community Manager

      Re : Utilisez-vous lag(x) ?

      Semble fonctionner correctement dans toutes les versions que j'ai essayées, y compris la 18.1.1.

      undefined

      Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

      hogi
      Level XII

      Re : Utilisez-vous lag(x) ?

      OK bien.

      Et c'est un peu étrange...

      Donc, ce n'est ni 100 % réparé, ni 100 % fonctionnel.
      qu'est ce qui fait la différence ?

      PC ou Mac ?
      ... Je vais vérifier mes préférences - et comparer avec plus de collègues.

      Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

      hogi
      Level XII

      Re : Utilisez-vous lag(x) ?

      La bonne chose :
      Ce n'est pas un problème général de « décalage »

      ... cela semble être causé par :

      undefined


      Lorsque je génère la formule de cette façon, les entrées sont vides.
      Lorsque je crée une nouvelle colonne et que j'ajoute la formule par la suite, les valeurs sont calculées.


      ajouté : vidéo avec différentes manières de générer la colonne de formules

      1. nouvelle colonne de formule : ajouter un décalage via un clic -> échouer
      2. nouvelle colonne de formule : ajouter un décalage manuellement -> échec
      3. nouvelle colonne de formule : supprimer le code et réécrire -> échec
      4. nouvelle colonne -> ajouter la formule manuellement -> fonctionne
      5. nouvelle colonne -> ajouter une colonne de formule via cliquer et écrire (comme #2) -> fonctionne

      Video Player is loading.
      Current Time 0:00
      Duration 0:00
      Loaded: 0%
      Stream Type LIVE
      Remaining Time 0:00
       
      1x
        • Chapters
        • descriptions off, selected
        • captions off, selected



          Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

          hogi
          Level XII

          Re : Utilisez-vous lag(x) ?

          J'ai envoyé un ticket au support JMP : TS-00182750
          Voyons ...

          Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

          jthi
          Super User

          Re : Utilisez-vous lag(x) ?

          Il semble que JMP évalue de manière incorrecte l'argument « manquant » de Empty()

          // Transform column
          Data Table("Big Class") << Apply Formula(
          	Columns(:weight),
          	Formula(Lag(:weight, Empty())),
          	Output(New Formula)
          );

          Si vous utilisez Lag sous Row, cela ne se produit pas car il utilise une autre méthode pour créer la colonne

          // New formula column: Lag[weight]
          Data Table("Big Class") << New Formula Column(
          	Operation(Category("Row"), "Lag"),
          	Columns(:weight)
          );

          Edit : Et cela arrive aussi avec d'autres fonctions (au moins avec Dif mais il pourrait y en avoir d'autres)

          // Transform column
          Data Table("Big Class") << Apply Formula(
          	Columns(:weight),
          	Formula(Dif(:weight, Empty())),
          	Output(New Formula)
          );
          

          Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).

          hogi
          Level XII

          Re : Utilisez-vous lag(x) ?

          Bonne remarque, merci @jthi d'avoir creusé plus profondément.


          Je n'ai jamais fait attention et j'ai remarqué les 2 façons dont l'éditeur de formule affiche les arguments facultatifs :

          1. explicite:
            undefined

          2. pas [juste dans la description] :
            undefined

          Ce message écrit à l'origine en English (US) a été traduit pour votre commodité. Lorsque vous répondez, il sera également traduit en English (US).