Interval Date with Set Analysis

[Mothapoe]

Good Day, I created below interval expression and I would like to add set analysis on it.

=Interval(Date(logged_date_key, 'YYYY/MM/DD') - Date(today(), 'YYYY/MM/DD'), 'DD')

I want below set analysis filters on above expression

{<Case_Status={'Follow Up','Open','Work In Progress'}>}

Your assistance will be greatly appreciated

[BrunPierre · Accepted solution]

Try this

=Interval(Avg({<Case_Status={'Follow Up','Open','Work In Progress'}>}Date(logged_date_key,'YYYY/MM/DD')-Date(today(),'YYYY/MM/DD')),'DD')