Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
i have a question that i can't resolve by myself after time... thanks for helping
I have a table of command & delivrey like this : extract for one "code-fournisseur"
I would like a table group by code fournisseur like This
Code-founisseur | Max delai | Min delai | Average | Median |
510 - PROMONET PROMED | 337 | 2 | 107 | 24 |
I try many solution but it doesent work .
Can you please help me for this ?
Thanks a lot
Try like below
Max: Max(Aggr(Urexpression, Code-founisseur))
Min: Min(Aggr(Urexpression, Code-founisseur))
Avg(Aggr(Urexpression, Code-founisseur))
Median(Aggr(Urexpression, Code-founisseur))
Can you say u expression or sample data?
Hello @MayilVahanan
Thank you . i don't understand how to do that.
In my tableau(picture)
the calculate field "max delai" is based on 'No cde (ec)' and "Max(dateRecep)-DateCommande"
When i try to apply it like your proposal :
Max(Aggr(Max(dateRecep)-DateCommande, Code-founisseur))
it don't works, and i try this to:
Max(Aggr(Max(DateRecep)-DateCommande,[Nb lig Cde (lc)],[Code - fournisseurs(fr)]))
it dont works anymore?
i don't understand what you mean : "Can you say u expression or sample data?"
Thank you to take time for my case