Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a set of work orders that are broken down into the following categories:
Age of the Work Orders by Trades
Trade 0-29 30-59 60-89 90+
A
B
C
The work orders can have various status but what I would like is a count of work orders in each of the 4 groups based on total new, and working. The other item is I only want work days which I believe is use the networkdays command.
Any help would be grateful.
Thanks,
I assuming your data as below.If yes you can write
sum({<Status={'New','Working'}>}0-29) + sum({<Status={'New','Working'}>}30-59) +
sum({<Status={'New','Working'}>}30-59) + sum({<Status={'New','Working'}>}90+)
Trade | Status | 0-29 | 30-59 | 60-89 | 90+ |
A | New | 1 | |||
B | Working | 1 | |||
C | New | 1 | |||
D | Working | 1 | |||
E |
Can you post a sample?
Bz what i believe, you have to do aging of workorders and then have to segregate the same as new and working