Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data Changes - Possible in Alteryx ?

suby
11 - Bolide

Hi All,

 

First of all apologize for raising this as a new post in the community.

 

Emil_Kos has provided solution which is close to my expected output and facing some challenges around that.

 

 

suby_0-1624460719761.png

 

suby_1-1624460750631.png

 

 

The Prop Code that was highlighted in Blue was there in previous Month but not in current month ( The missing Prop code should be reported in the current month is where I'm facing the challenge)

 

Always the calculation has to be dynamic so 

that when i filter the dates 30.10.2016 as current it has to check 30-09-2016

 when i filter the dates 30-09-2016 as current it has to check 31-08-2016

 

Attached the Emil_Kos solution  workflow.

 

Kindly appreciate if the people in the community can help.

0 REPLIES 0
Labels