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.
SOLVED

Multi Row Formula Help

dquimby
5 - Atom

Hi - I've been struggling with this for a couple of days so any help would be greatly appreciated. I have a data set with an event ID, Close of Business and Event Severity (and a million other fields). I want to write a calculation where I can tag an event ID when the severity changes from one month to another. I've tried the formula tool, the multi row formula and a bunch of other things and can't seem to get my desired output. 

 

Event IDClose of Business DateEvent Severity
444332020-06-01Medium
444332020-07-01Medium
444332020-08-01Medium
444332020-09-01Medium
444332020-10-01Low
555132020-06-01Medium
555132020-07-01Medium
555132020-08-01Medium
555132020-09-01Medium
555132020-10-01Low

 

The end result would be to plug my data set into tableau and for any given reporting month, show a table like this:

 Sample Table.png

 

My thought process is that I would need to flag the Event ID 44433 and 55513 in the 2020-10-01 and 2020-11-01 rows but I haven't been able to get that to work in conjunction with my tableau view. any suggestions?

 

Thanks in advance. 

4 REPLIES 4
PhilipMannering
16 - Nebula
16 - Nebula

Hey @dquimby 

 

Maybe something like this?

PhilipMannering_0-1605898982633.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Or if you wanted to label change to before and after, then it's a minor change...

messi007
15 - Aurora
15 - Aurora

Dear @dquimby,

 

Please check the workflow below:

 

messi007_0-1605899783356.png

 

Attached the workflow as well.

 

Hope that helps.

 

Regards,

dquimby
5 - Atom

@PhilipMannering 

Yes! Thank you so much. So simple. Now I just need to create a calculated field in tableau so when I filter by reporting month, the current and previous months are in the view. 

 

Thanks!

Labels