Show queue with data from WMS-system

[DataJoe]

Hi,

I'm having a problem building a report, which is going to live stream a view of queues in our production.

I want a table/Matrix for each date, which shows the info like below, with a hidden filter which shows priority 1 and 2 etc(See SQL data below).

Queues both have a Ready column and a Done column, see below.

Status 1 - Ready

Status 2 - Done

Dispatch date: 10.05.2019
Store	Pick lines	Queue1	Queue2	Queue3
1 2 …	1 (50) 1 (37)	0 (0) 0 (0)	1 (50) 1 (37)	0 (0) 0 (0)	0 (0) 0 (0)	0 (0) 0 (0)	0 (0) 0 (0)

Dispatch date: 13.05.2019
Store	Pick lines	Queue1	Queue2	Queue3
1 2 6	9 (282) 12 (344) 10 (272)	5 (76) 9 (116) 8 (82)	0 (0) 0 (0) 0 (0)	3 (205) 3 (228) 2 (190)	0 (0) 0 (0) 0 (0)	1 (1) 0 (0) 0 (0)	0 (0) 0 (0) 0 (0)

How my data looks in SQL:

Store	Queue1	Queue2	Queue3	Status	orderno	Date	Pick lines	Priority
Store1	1	NULL	NULL	Ready	1234567	10.05.2019	16	1
Store2	NULL	1	NULL	Ready	7654321	10.05.2019	54	2
Store3	NULL	NULL	1	Done	987564	13.05.2019	3	3
Store4	1	NULL	NULL	Ready	947613	15.05.2019	19	1

I have tried to do it with a table and a matrix, but with no luck. 

[witkob]

Hello, DataJoe, I'm wondering if you find your own solution for this problem. I'm facing familiar issue right now, and maybe from 2019 you figured something...

[DataJoe]

Hi Witkob,

I just 'cheated' and made 3 tables with overlab, and hided the one with no data. I did not find an easy way, to solve this problem.  Hopefully this helps?

[v-frfei-msft]

Hi @DataJoe ,

I cannot get the logic between your tables and excepted result. Could you please share a sample to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[DataJoe]

Hi Frank,

The data is just a 'imaginary' data, because of confidential data, so this is not an option, sorry.

I'll try to explain otherwise:

I need a table/matrix for each date with the 4 queues attached. F.x If I have a dispatach date 10.05.2019, I will need a table/matrix, which shows data for each store with a order no. the following date, sorted by pirority column.

F.x 

If I have a dispatchdate the 14/5/19, this needs to be shown, sorted by pirority, lowest value on top(With a hidden filer, becuse the priority column needs to be hidden in the table/matrix). This needs to be shown, so the workers know which queue are the first to proceed with.

Dispatch date:
14/05/19
Store:	Queue1:	Queue2:	Queue3:	Queue4:
Store4	1	NULL	NULL	NULL
Store7	NULL	1	NULL	NULL

Data:

Short explanation of data:

A store can only have 1 order no. pr queue.

Store name	Queue1	Queue2	Queue3	Queue4	Priority	Status	Order no.	Rute no.	Dispatchdate
Store1	1	NULL	NULL	NULL	1904080400	Not ready	308956	Rute1	27/05/19
Store2	NULL	1	NULL	NULL	1904080401	Not ready	308964	Rute2	26/05/19
Store3	NULL	NULL	1	NULL	1904080401	Not ready	308964	Rute3	28/05/19
Store4	NULL	1	NULL	NULL	1904080401	Not ready	308964	Rute1	14/05/19
Store5	NULL	NULL	1	NULL	1904080401	Not ready	308964	Rute2	28/05/19
Store6	1	NULL	NULL	NULL	1904080402	Not ready	308961	Rute4	19/05/19
Store7	NULL	1	NULL	NULL	1904080403	Not ready	308959	Rute3	14/05/19
Store8	NULL	NULL	1	NULL	1904080403	Not ready	308959	Rute5	28/05/19

Hopes this gives you a better explanation?