Pull in Current & Prior Month's Data Using Interface Tool

Hi everyone,

I'm trying to find the best way to accomplish the following:

The user identifies the "Current Month" using the Interface tool
Isolates the "Current Month" and "Prior Month"

For example, if I select February 2019, I want it to pull in February 2019's data for the "Current Month" and January 2019's data for the "Prior Month".

I'm not sure the order in which I need to do everything, which is why I believe I'm having problems. Any assistance would be greatly appreciated.

Thanks!

-T

Sample Workflow_Monthly Data.yxmd

Workflow

Developer Tools

Interface Tools

Accepted answers

CharlieS

Thanks for sharing the data. Check out the attached workflow and let me know if this works for you.

20190606-MonthlyData.yxzp

All comments

CharlieS

The .csv file in your workflow is not included when you just attached the .yxmd file. I suggest exporting the workflow (Options>Export Workflow) to include this file, or use a Text Input tool to replicate the fields and values of this file so that we can better help with formulas.

thenning

My apologies. Please see the attached for the exported workflow.

Sample Workflow_Monthly Data.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703