Generate a sequence for Orders each day

[Anonymous]

Hello! I need some help generating a sequence for orders that restarts each day. Currently I have a sequence column in my xlsx but it counts 1 to end of document. I would like the sequence to be based off of order times and restart each day. 

Example of current state:

Sequence	Date	Order	Time
1	Feb 15	A	8:00
2	Feb 15	B	8:01
3	Feb 16	C	8:00
4	Feb 17	D	8:00

Example of desired State:

Sequence	Date	Order	Time
1	Feb 15	A	8:00
2	Feb 15	B	8:01
1	Feb 16	C	8:00
1	Feb 17	D	8:00

Thanks!

[amitchandak]

@Anonymous , Create a new column like

countx(filter(Table, [Date] = earlier([Date]) && [Order Time] <= earlier([Order Time]) ),[Order Time])

[Anonymous]

@amitchandak 

This is pretty close, 

This is what I put for the new column

Seq = COUNTX(FILTER(AMSformatted, [Prod Date] = EARLIER([Prod Date]) && [time_seq] <= EARLIER([time_seq])),[time_seq])

But it is counting by 2's in some areas

 and by 1 in other areas