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.
Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
I need to count how many times something occurs with less than a minute between each occurrence.
I decided to create a new column that starts at 0 and adds one every time the idle duration exceeds 60sec and then group by cluster using the summary tool and count the number of members to that cluster (identified by the unique number).
However, the In-Database formula took keeps giving me an error.
I don't know exactly which database type you are connecting to, but most have a LAG/LEAD analytic function (aka Alteryx Multi-Row) to find the time differences and a ROW_NUMBER() to get a unique counter (aka Alteryx RecordId). It is a shame to have it IN-DB and bring it back until you've done the bulk of your work.
You may need multiple formula tools as I don't believe you can created a field in one and also reference the same field again later in the tool. Each IN_DB tool is building SQL behind the scenes so you may need one to determine if the times are <> 60 seconds and then another formula to add the RowNumber().