Create Records based on a Date

[Samvee1]

Hi there,

I am trying to record time savings for various projects. My input data would include the various projects, the month they were implemented, and then a $ value each project has saved per month.

What I am trying to get Alteryx to do is generate records per month based on that data compared to todays date. So if Project A was implemented in June, there would be a record for June, July, August and September. If Project B was implemented in August, then there would be only be records for August and September.

The goal is for the app user to be able to select a date range when running a report, and then each project is reported correctly.

Any ideas?

[caltang]

Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.