Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Multi Row Formula Help

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hey @dquimby 

 

Maybe something like this?

PhilipMannering_0-1605898982633.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
Alteryx Partner

Dear @dquimby,

 

Please check the workflow below:

 

messi007_0-1605899783356.png

 

Attached the workflow as well.

 

Hope that helps.

 

Regards,

Highlighted
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