aging interval

[BRI]

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

[BRI · Accepted solution]

solved 😉