Aggregated Data

dunnalahk123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can some one help me writing below Aggregated function

i have metric which i am writing below aggregated expression

For E2E TAT Metric :

=Num(Avg(Aggr(Avg([E2E Deployment TAT]), [E2ETATPROJECTID])),'#,##0' ) >>>> it works fine

Days:

=Num(Avg(Aggr(Avg([Days]), [E2ETATHOLDPROJECTID])),'#,##0' ) >>>> it works fine

Sch Days:

=Num(Avg(Aggr(Avg([SCHDays]), [E2ETATHOLDPROJECTID])),'#,##0' ) >>>> it works fine

For E2E TAT HOLD:

=Num(Avg(Aggr(Avg([E2E Deployment TAT – Hold]), [E2ETATHOLDPROJECTID])),'#,##0' ) >>>> it works fine

BUT for E2E TAT HOLD Calculation is

E2E TAT - (Days+Sch Days)

so from above table box

E2E TAT HOLD per individual project ID it works fine

309 - (189+19) =101

268- (37)=231

but when it comes to total

288.5 -(113+19) i am getting 166 as per my

Num(Avg(Aggr(Avg([E2E Deployment TAT – Hold]), [E2ETATHOLDPROJECTID])),'#,##0' )

but it should get 156.5

how can i write

topic Aggregated Data in QlikView