Skip Navigation
Expand
Order of results in Activities by capacity categories report
Answer ID 8634   |   Last Review Date 07/08/2019

Is it possible to keep the same order of capacity categories in the report "Activities by capacity categories"?

Environment:

Oracle Field Service, All versions

Issue:

I've checked the report "Activities by capacity categories" for this month and last month and the order of capacity categories is not the same

Resolution:

The layers of capacity categories are put in order based on the Capacity categories IDs day by day, as they appear from the first day of the month and further on. If you want to have the same order of capacity categories each month, you should have activities with all work skills to be used during the first day of the month (or the second, if the first day has 0 activities).

To have a better understanding of this, please see example below:

queue date   |        ID | Capacity category
---------------------------------------------------
  2016-01-01 |        31 | A        

  2016-01-02 |        31 | A             
  2016-01-02 |        33 | C    
  2016-01-02 |        34 | D      

  2016-01-03 |        31 | A        
  2016-01-03 |        32 | B    
  2016-01-03 |        35 | E      

  2016-01-04 |        31 | A        
  2016-01-04 |        32 | B          
  2016-01-04 |        33 | C    
  2016-01-04 |        34 | D
  2016-01-04 |        35 | E        

1. Get all capacity categories for Jan 1st, sort them by ID, ignore already known:
A (Category A) - 31

2. Get all capacity categories for Jan 2nd, sort them by ID, ignore already known:
A - already taken into account above
C (Category C) - 33
D (Category D) - 34

3. Get all capacity categories for Jan 3rd, sort them by work skill id, ignore already known:
A - already taken into account above
B (Category B) - 32
E (Category E) - 35

4. Get all capacity categories for Jan 4th, sort them by work skill id, ignore already known:
A, B, C, D, E - already taken into account above

Final order displayed to the user in Dashboard will be, from bottom to the top: A, C, D, B, E:

Image showing order from bottom to the top: A, C, D, B, E