How to number occurrence in a new column. Sequence

[RKGV]

Hi Experts,

I have incidents for a batch occurring in different days and I want to number it based on the occurring sequence.   

Attached the sample file.

Thanks in Advance

[atcodedog05]

Hi @RKGV 

ok ok did you make sure to check the incident in groupby options

Anyways if @Qiu solution is working ignore mine thanks for checking.

Happy to help : )

Cheers and have a nice day!