Tile Tool

[hayley93]

Hi, 

I have the data like below. I used tile tool to group by the department to provide unique ticket number. After the grouping like 20081803(yyMMdd+03) for CS department, I want to provide different ticket number to CS. But, as I grouped by Department, it will output the same ticket number used before. Does anyone have any idea to tackle this? 

Department	Date & Time	Ticket No
HR	10:58 AM 2020/08/18	20081801
HR	11:00 AM 2020/08/18	20081801
HR	11:04 AM 2020/08/18	20081801
Marketing	11:04 AM 2020/08/18	20081802
Marketing	11:04 AM 2020/08/18	20081802
CS	11:34 AM 2020/08/18	20081803
CS	13:00 PM  2020/08/18	20081803 20081804
HR	13:59 PM 2020/08/18	20081801 20081805
HR	14:00 PM  2020/08/18	20081801 20081805

Thank you!! 

[patrick_mcauliffe]

If I'm following the use case correctly... would it work to just add a formula that would append the department name to the ticket number or does the ticket number need to be strictly numeric?

If numeric is required, you could... make it a decimal and append with tonumber(tostring([ticketnumber])+'.'+tostring(tile_num))

[Ladarthure]

Hi @hayley93,

if I understand well your problem, you could use a multi row formula and use the group by function to group by date/departement. (here is a workflow attached)

[DavidP · Accepted solution]

Hi @hayley93 

If you use the Tile tool (without Group By) with option Unique Value based on Department, but check the Leave Unsorted box, it works like a Multi-Row formula, i.e. if [Department]!=[Row-1:Department] then [Row-1:Tile_Num]+1 else [Row-1:Tile_Num] endif

This is shown below. It you uncheck the Leave Unsorted Box, it Groups and Sorts all the same Departments together in a Tile. 

With both options, Tile_Sequence_Num gives you the Unique ID within each group.