Week on week comparison

khadar — Thu, 10 Feb 2022 12:02:03 GMT

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

Re: Week on week comparison

chris_djih — Fri, 11 Feb 2022 10:46:04 GMT

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?

topic Week on week comparison in App Development

Week on week comparison

Re: Week on week comparison