hello ,
the following calculation form:
TU = sum(Aggr(count(if(match([Type de commande], 'URGENT','GROS', 'PVI'), [N° ligne])),[N° donneur d'ordre]))/Aggr(sum(Aggr(count([N° ligne]),[N° de commande])),[N° donneur d'ordre])
I want to draw a Line Chart of TU in relation to [N° donneur d'ordre]) Last 6 months of this year
Like this :