how can I count rows by time and category.

[Pobthams]

 

 

According to the image, I want to create a column that shows the number of previous orders. The orders have to be counted separately by store and reset every day.

[amitchandak · Accepted solution]

@Pobthams , Create a new column like

countx(filter(Table, [Store] = earlier([Store]) && [date] = earlier([Date]) && [time] < earlier([Time])),[Time])+0

[Pobthams]

@amitchandak What if I want to count orders between 3 PM from the day before until the latest order, and reset every day at 3 PM.