Query error

[Shabnam123]

I need to count process_id based on condition

Count(
DISTINCT 
If(
Aggr(NODISTINCT Max(process_strt_tm), process_id) = process_strt_tm
AND process_status = 'Completed' , 
process_id
)

But before this, I need to add an extra condition that catalog_type='xyz' 
How to do this?

[TauseefKhan]

Check This :

Count(
DISTINCT
If(
Aggr(NODISTINCT Max(process_strt_tm), process_id) = process_strt_tm
AND process_status = 'Completed'
AND catalog_type = 'xyzzy',
process_id
)
)

[Shabnam123]

No. I need to choose catalog_type first and then apply rest of condition

[TauseefKhan · Accepted solution]

Count(
DISTINCT
If(
Aggr(NODISTINCT Max({<catalog_type={'xyzzy'}>} process_strt_tm), process_id) = process_strt_tm
AND process_status = 'Completed',
process_id
)
)