Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')