Hello wise people,
I need some help on a specific query. I'm trying out a simple BI to help manage the employees queue work rates.
There are two types of queues; Production and non- Production. Production Codes will have volumes ranging from 0 to any number and the non production codes will have "-". Please see below.
<tbody>
</tbody>
I want to dynamically create two simple separate lists for Production and non production. Please see below for desired result.
<tbody>
</tbody>
I do not want to use pivot tables and I would appreciate if someone could help me achieve the desire result without the use of Ctrl+Shift+Enter.
Many thanks in advance.
I need some help on a specific query. I'm trying out a simple BI to help manage the employees queue work rates.
There are two types of queues; Production and non- Production. Production Codes will have volumes ranging from 0 to any number and the non production codes will have "-". Please see below.
Queue | Time Taken | Volumes |
Production Queue 1 | 1:00 | 1 |
Production Queue 2 | 0:30 | 0 |
Meal Break | 0:45 | - |
Production Queue 2 | 1:30 | 2 |
Staff Meeting | 0:20 | - |
Production Queue 1 | 1:00 | 2 |
Production Queue 2 | 0:45 | 1 |
System Down | 0:10 | - |
<tbody>
</tbody>
I want to dynamically create two simple separate lists for Production and non production. Please see below for desired result.
Production | Non Production | |
Production Queue 1 | Meal Break | |
Production Queue 2 | Staff Meeting | |
System Down |
<tbody>
</tbody>
I do not want to use pivot tables and I would appreciate if someone could help me achieve the desire result without the use of Ctrl+Shift+Enter.
Many thanks in advance.
Last edited: