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
@RKGV Add some dummy data
Hi @RKGV - Here is a possible solution:
@RKGV The Tile tool should be a good fit here.
Thanks for reply.
I want to exclude incrementing if it occurs on the same date.
For Ex:
2022-01-01 BATCH 1 1
2022-01-01 BATCH 2 1
2022-01-03 BATCH 1 2
@ArtApa @Qiu
both of your answer works for me. Please help with above query.
Hi @RKGV
My take on this
Hope this helps : )
@atcodedog05 sorry i put it in my problem.. it just increments every row.
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!
