This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
I have the following daily production data for each machine and I need to identify all the dates where the machine did not work for a minimum of 3 days. I should count dates only after the machine worked for at least 3 consecutive days. For example, Jan 2-4 below should not be counted because the machine did not work for 3 consecutive days yet until those dates.
@Qiu, The machine should work for at least 3 consecutive days (>0 production) before we identify consecutive zeros. Therefore, we should start identifying consecutive min 3 days zeroes after Jan 7 for Machine A because it worked for 3 consecutive days first time on Jan 5-7.
3 consecutive production days not necessarily need to be immediately before the 3 consecutive zero production days. It can be at anytime in the dataset. In this case, there is a consecutive 3 days production at Jan 5-7 and we can start counting consecutive zero productions after Jan 7. Thank you!