Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a document that needs to be published and emailed in current month and previous month states. The document contains (Previous months) data as well as current month. When previous month is chosen, it should so last month as current and previous month as current month - 2). If I use the reduce data feature on the task, and set date= last month flag, it removes all data that isnt equal to last month, so the Previous month no longer calculates. Is there anyway to filter data rather than reduce? Or alternatively, set a variable in a task that would set today as last month?
Hi @bcraymond, you can try adding another field to the dates to use as a flag (current and previous month dates will be flagged), so you can try reducing data based in that flag