hi, I'm trying to group my tickets on the basis of aging in day (today-Open_time) with something like this but is not working
I need then to use AGING as dimension on charts
LAST_DATA:
NoConcatenate
LOAD [Incident ID],
[Open Time],
(Day(Today())-Day([Open Time])) as DD_difference,
if((DD_difference)<=7,'0-7',
if(DD_difference>=8 and DD_difference<=15,'8-15',
if(DD_difference>=16 and DD_difference<=30,'16-30',
if(DD_difference>=31 and DD_difference<=45,'31-45',
if(DD_difference>=46 and DD_difference<=90,'46-90','91 and more'))))) as AGING,
thanks for the support
ciao
Bri
