getting the min date in an average of networkdays

[JacobJones]

So this is what I want to work:

AVG( NetWorkDays([AxUDV_CaseTriage.Date Case Received], min([Date of Appointment]), Holiday)))

but I am getting the error, Nested aggregation is not allowed. In the table one Patient ID has multiple appointments and I want to calculate the time between the Date Case Received and the first appointment. I've tried set analysis and aggr(), but so far no luck.

How can I do this?

[Vegar]

Do you bet a correct value if you remove the avg() and select a single patient?

If patient ID is a dimension in your table then you should probably  try to aggregate on that dimension.

AVG( NetWorkDays([AxUDV_CaseTriage.Date Case Received], min([Date of Appointment]), Holiday), [Patient ID])

[JacobJones]

The error is with the nested aggregation. 

[sunny_talwar · Accepted solution]

How about this

Avg(Aggr(
  NetWorkDays([AxUDV_CaseTriage.Date Case Received], Min([Date of Appointment]), Holiday)
, [Patient ID]))

[JacobJones]

Thank you so much 🙂