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? DepartmentDate & TimeTicket NoHR10:58 AM 2020/08/1820081801HR11:00 AM 2020/08/1820081801HR11:04 AM 2020/08/1820081801Marketing11:04 AM 2020/08/1820081802Marketing11:04 AM 2020/08/1820081802CS 11:34 AM 2020/08/1820081803CS13:00 PM 2020/08/18 20081803 20081804HR13:59 PM 2020/08/18 20081801 20081805HR14:00 PM 2020/08/18 20081801 20081805 Thank you!!

Tile Tool

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!!

Developer Tools

Date Time

Dynamic Processing

Accepted answers

DavidP

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.

Tile with Leave Unsorted.yxmd

All comments

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)

sample_ticket_ID.yxmd

DavidP

Hi @hayley93

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.

Tile with Leave Unsorted.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703