Aggr Avg Calc

[cbaqir]

My Avg days assigned calc isn't working if there is more than 1 DEFECT_ID. Any suggestions?

Dimension: 

=if(match(CUR_STATUS,'Closed', 'Deferred', 'Denied', 'Closed - Maintenance', 'Dismissed', 'Nursing Research & Analytics')>0,null(),dual( Month(ERC_ASSIGNED_DATE) & '-' & Year(date(ERC_ASSIGNED_DATE,'DD.MM.YY')), num(Year(ERC_ASSIGNED_DATE)) & num(Month(ERC_ASSIGNED_DATE), '00' )))

Expression:

aggr(avg(today()-ERC_ASSIGNED_DATE),BUILD_RESOURCES_SUB,ERC_ASSIGNED_DATE)

[Brett_Bleess]

Cassandra, odd nobody took a stab at things here given you did attach your QVW, this will kick things back up to the top, maybe someone will see it now and leave you something.  About all I have is the following, not sure if it will actually help or not...

https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

There are some other posts in the Design Blog area as well, so here is the main link you can use to search yourself, but maybe the above might help you get things sorted on your own.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[Frank_Hartmann]

avg(aggr(avg(today()-ERC_ASSIGNED_DATE),DEFECT_ID,CUR_STATUS))

or 

avg(aggr((today()-ERC_ASSIGNED_DATE),DEFECT_ID,CUR_STATUS))

See attached qvw

hope this helps