Generate ID based on chaning dimension

[Yury_Brunt]

Hello,

I need to generate an ID based on the changing status, like in the example below.

Each ID must be based on a fixed text including the first date-time field when the status changes. 

Anyone an idea how to do that?

[LordNeilLord · Accepted solution]

Hey @Yury_Brunt

Multirow again for this one! Read up about Multirow, it's super powerful :)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[BenMoss]

@LordNeilLord am I right in thinking the data needs to be sorted prior to the multi-row else this may cause issues?

Ben

[LordNeilLord]

@BenMoss I would have thought so. Looking at the example provided by @Yury_Brunt the data already seems to be in the correct order

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[Yury_Brunt]

Perfect! Thanks again for your help!