I have a scenario where I need to identify the recurrence of the same incident category on a computer.
Each incident record tracks the computer name, the date, and the category of the incident.
I want to highlight those computers which had in the past 3 days the same category of incident.
My dataset is more extended with many other categories that classify an incident, but for sake of simplicity, I attached a barebone example. I had figured out I could use the churn and returning customer pattern, but after some hours of testing I got nothing valid.
I don’t need an off the shelf solution, rather a direction to what you think might be the best approach
Thanks and regards