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.
I'm having a hard time trying to figure out how to filter data based on a date that's returned in a prior step in the same workflow. I have the following summarized data by posting date, and since 2019-10-25 has the largest positive number, it is the effective date that I need. For the next step, I need to filter the original non-summarized data by selecting all of the posting dates on and after the effective date 2019-10-25. Since they are within the same workflow, I don't know if it's possible to accomplish this. I could select the 2019-10-25 date by sorting and sampling, but I don't know how to use this date result back to the workflow for the next step filtering. Please help!! Thank you!
@yyu3 You can use the append fields tool to append the total (sample top 1, biggest number) to every dataset. You can then use the sort tool to sort based on the biggest number, and then a sample tool, top 1, group by the date to grab the biggest data.