Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I'm struggling whith what seems to be a simple requirement.
I have a table with ArticleID, Date, Stock break date.
I need to count ArticleIDs where there was a stock break for more thank 5 consecutive days.
Thanks in advance.
Costa,
Can you please provide a sample data set for this requirement. Well you can use group by to find the stock break count and then get the desired output.