Week on week comparison

[khadar]

Hi All,

 looking for someone who can help me on below.

Actually I got requirment where I have to show Status like OLD/NEW/ Resolved by comparing the data week on week.

 let say one Cusotmer (RR) has booked incident  on 01/06/2022  and since it wasn't resloved in week his ID is came into second week 08/06/2022.  by comparing 1 & 2 week for 1'st have to show as NEW and second have to show as OLD since HIS ID availabe in second week too. 

Similarly same ID has to compare in the third week, if it isn't availabe then have to show the statu as Resloved.

can you pls help me out with back logic of it. I tried with below script and able to achieve old & new only

If(ID= peek(ID),'OLD,'NEW')

Regards,

khadar

[chris_djih]

do better understand your need it try to reformulate your problem. please verify if i got this correctly.
You want to display for the Customer RR:

• The week the incident appeared as "NEW"
• the week the incident disappeared as "Resolved"
• any other weeks between as "OLD"

Is this correct? Do you have to display this for each incident or aggregated by customer? what if the customer has several incidents?
How do you want to display it? table? heatmap?