Ticket Open Greater Than Days

[sunil-kumar5]

Hi All,

I have columns name like ticket number, date, ticket_status(Open, Closed).

I wanted to create a dimension having ticket open with >3days,>5days,>7days and >10day on the basis of date when ticket was created and using status open and measure will be ticket count.

Please advise.

Thanks

[Dalton_Ruer]

Best way to handle that is in your load script. Here is a snippet of code that does something very similar. It's just a big nested IF condition that outputs the "range" desired to a new field that you can refer to. 

if(Interval("AUGDT" - "BUDAT", 'DD')<=30,'0-30 Days',
   if(Interval("AUGDT" - "BUDAT", 'DD')<=60,'30-60 Days',
      if(Interval("AUGDT" - "BUDAT", 'DD')<=90,'60-90 Days',
         if(Interval("AUGDT" - "BUDAT", 'DD')<=180,'90-180 Days', '180+')))) as [DSO Range],