Hey Guys,
I need your help.
I want to create a Chart where I can see how the Ticket ID moved between Queues.
So When a Ticket from a Customer is created, it is generated in the first Queue. with Time it changes its queue because maybe the FirstQueue wasnt the right one to answer the question and so on.
So in the First Row it would be That the TicketID 120270 was:
first in the Queue 5,
then in the second queue 38
then in the third queue 47
then in the fourth queue 35
...
How can I create something like that in a chart,so when I choose in a list the FirstQueue 5 how can I see the aggegrated Movement of all the tickets in this Queue?
LOAD * INLINE [
ID, FirstQueue, SecondQueue, ThirdQueue, FourthQeue, FifthQueue, sixthQueue, seventhQueue, ninthQueue
120270, 5, 38, 47, 35, 44, 75, ,
123983, 33, 51, 22, 75, 49, 60, 56, 27
126461, 5, 49, 10, 60, 56, 27, ,
130223, 24, 22, 50, 80, 12, 34, 60,
136382, 5, 34, 38, 22, 75, 12, ,
143071, 5, 10, 82, 47, 56, 80, ,
151722, 33, 35, 47, 8, 50, 80, ,
];