cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-608297%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3ERi%3A%20opzione%20di%20aggregazione%20per%20i%20join%20virtuali%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-608297%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F42584%22%20target%3D%22_blank%22%3E%40Sarah%20Sylvestre%3C%2FA%3E%20%3C%2FP%3E%3CP%3Equesta%20funzionalit%C3%A0%20potrebbe%20aiutare%20molto%20a%20migliorare%20l'usabilit%C3%A0%20dei%20virtual%20join.%3CBR%20%2F%3E%20(Lo%20ammetto%3A%20sicuramente%20non%20alla%20stessa%20velocit%C3%A0%20di%20cui%20godiamo%20senza%20aggregazione)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-609736%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EOggetto%3A%20opzione%20di%20aggregazione%20per%20i%20join%20virtuali%20-%20Stato%20modificato%20in%3A%20Riconosciuto%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-609736%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGrazie%20per%20tutte%20le%20informazioni%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F26800%22%20target%3D%22_blank%22%3E%20%40hogi%3C%2FA%3E%20!%20La%20tua%20richiesta%20%C3%A8%20stata%20acquisita%20e%20avr%C3%A0%20la%20priorit%C3%A0.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-473024%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3Eopzione%20di%20aggregazione%20per%20i%20join%20virtuali%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-473024%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E2%98%90%20nuova%20fantastica%20funzionalit%C3%A0%3CBR%20%2F%3E%20%E2%98%90%20potrebbe%20aiutare%20molti%20utenti!%3C%2FP%3E%3CP%3E%E2%98%90%20rimuove%20un%20%22bug%22%3C%2FP%3E%3CP%3E%E2%98%91%20bello%20averlo%3C%2FP%3E%3CP%3E%E2%98%90%20nessuno%20ne%20ha%20bisogno%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fforums%2Fsearchpage%2Ftab%2Fmessage%3Ffilter%3Dlocation%2CauthorId%26amp%3Bq%3Dfeature%26amp%3Blocation%3Didea-board%3Ajmp-wish-list%26amp%3Bauthor_id%3D26800%22%20target%3D%22_self%22%3Ealtri%20desideri%20presentati%20da%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22hogi_2-1702196401638.png%22%20style%3D%22width%3A%2036px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F59505i92BA52D1289B6F5C%2Fimage-dimensions%2F36x39%3Fv%3Dv2%22%20width%3D%2236%22%20height%3D%2239%22%20role%3D%22button%22%20title%3D%22hogi_2-1702196401638.png%22%20alt%3D%22hogi_2-1702196401638.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EL'idea%3A%3C%2FP%3E%3CP%3Ese%20non%20%C3%A8%20presente%20un%20identificatore%20univoco%20per%20il%20virtual%20join%3A%20aggiungi%20la%20possibilit%C3%A0%20di%20definire%20un'aggregazione%20per%20generare%20valori%20univoci.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3Enon%20%C3%A8%20necessario%20avere%20un%3CSTRONG%3E%20unico%3C%2FSTRONG%3E%20identificatore%20per%20i%20join%20virtuali%20pi%C3%B9%3C%2FLI%3E%3CLI%3Eun'opzione%20predefinita%20per%20l'aggregazione%20dei%20dati%20%5B%22mediana%22%20sarebbe%20interessante%2C%20ma%20funziona%20solo%20per%20i%20numeri%3B%20quindi%20la%20%22N%22%20non%20%C3%A8%20cos%C3%AC%20utile%3F%5D%3CBR%20%2F%3E%20%2B%20la%20possibilit%C3%A0%20di%20definire%20l'aggregazione%20individualmente%20per%20ciascuna%20colonna%20(come%20nel%20generatore%20di%20query)%3C%2FLI%3E%3C%2FUL%3E%3CP%3Eil%20vantaggio%3A%3C%2FP%3E%3CUL%3E%3CLI%3El'opzione%20di%20aggregazione%20rende%20l'unione%20virtuale%20molto%20pi%C3%B9%20versatile%3C%2FLI%3E%3CLI%3Eil%20virtual%20join%20%C3%A8%20quasi%20altrettanto%20%22dinamico%22%20quanto%20la%20funzionalit%C3%A0%20di%20collegamento%20della%20tabella%20di%20riepilogo%20(%26lt%3B-%26gt%3B%20Query%20Builder)%3C%2FLI%3E%3CLI%3Ei%20collegamenti%20virtuali%20sopravvivono%20dopo%20che%20i%20dati%20sono%20stati%20salvati%20e%20riaperti%20(%26lt%3B-%26gt%3B%20tabella%20dei%20collegamenti)%3C%2FLI%3E%3C%2FUL%3E%3CP%3Elo%20svantaggio%3A%3C%2FP%3E%3CP%3El'aggregazione%20rallenter%C3%A0%20il%20virtual%20join.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ela%20soluzione%3A%3C%2FP%3E%3CUL%3E%3CLI%3Eaggregazione%20tramite%20tabella%20riepilogativa%3C%2FLI%3E%3CLI%3Epartecipare%20tramite%20collegamento%20virtuale%3C%2FLI%3E%3CLI%3Eimportante%3A%20salva%20come%20script%3CBR%20%2F%3E%20(per%20ristabilire%20il%20collegamento%20dinamico%20dopo%20che%20si%20%C3%A8%20perso%20dopo%20il%20salvataggio%20del%20file)%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-473024%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EAccesso%20ai%20dati%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
0 Kudos

aggregation option for virtual joins

☐ cool new feature
☐ could help many users!

☐ removes a „bug“

☑ nice to have

☐ nobody needs it

other wishes submitted by  hogi_2-1702196401638.png

 

The idea:

if there is no unique identifier for virtual join -- add the possibility to define an aggregation to generate unique values.

 

  • no need to have a unique identifier for virtual joins anymore
  • a default option for data aggregation ["median" would be cool, but just works for numbers; so the not so useful "N"?]
    + a possibility to define the aggregation individually for each column (like in the query builder)

the benefit:

  • the aggregation option makes the virtual join much more versatile
  • the virtual join is almost as "dynamic" as the link functionality of summary table (<->  Query Builder)
  • virtual links survive after the data is saved and re-opened (<-> link table)

the disadvantage:

the aggregation will slow down the virtal join.

 

the woraround:

  • aggregation via summary table
  • join via virtual link
  • important: save as a script
    (to establish the dynamic link again after it got lost after saving the file)
2 Comments
hogi
Level XII

@Sarah-Sylvestre 

this functionality could help a lot to improve the usability of virtual joins.
(I admit: definitely not at the same speed that we enjoy without aggregation)

Status changed to: Acknowledged

Thank you for all the information @hogi! Your request has been captured and will be prioritized.