Resource gauges

Beas dashboards > Using the dashboards > Resource dashboard > Resource gauges

Top  Previous  Next

Usage rate

DASHBO~1_img16

This gauge shows the percentage of the actual resource utilization from the planned capacity for all resources.

This indicator includes by default the last 3 months as the data range, active resources only with capacity planning and it excludes the resources set for service or cost.

 

Data Items used

Description

View/Table field

Planned Capacity

Sum of the hours for the planned capacity in the last 3 months.

View: "BEASV_RESOURCE_UTILIZATION"."PlannedCapacity"

Actual Use

Sum of the hours for the actual use in the last 3 months.

View: "BEASV_RESOURCE_UTILIZATION"."ActualUtilization"

 

Planned usage rate for the next two weeks

DASHBO~1_img17

This linear gauge shows the percentage of the planned work time for the resources from their planned capacity.

This indicator includes by default the next 2 weeks as the data range, active resources only with capacity planning and it excludes the resources set for service or cost.

 

Data Items used

Description

View/Table field

Reserved Time

Total reserved working time for the resources in the next 2 weeks.

View: BEASV_RESERVED_TIME.ReservedTime

Date range:

COALESCE((SELECT SUM(BEASV_RESERVED_TIME."ReservedTime") * 1.0 / 60.0 
   FROM "BEASV_RESERVED_TIME" WHERE BEASV_RESOURCE_UTILIZATION."ResourceId" = BEASV_RESERVED_TIME."ResourceId"
    AND (BEASV_RESERVED_TIME."ToDateTime" <= ADD_DAYS(NOW(), 15) AND "FromDateTime" > NOW())), 0) AS "ReservedTime"

Planned capacity in the next two weeks

Total hours of the planned capacity of the resources.

COALESCE(SUM("PlannedCapacity"), 0) AS "PlannedCapacity"

Next two weeks date range:

WHERE (BEASV_RESOURCE_UTILIZATION."Date" <=  ADD_DAYS(NOW(), 15)
 AND BEASV_RESOURCE_UTILIZATION."Date" > NOW())

 

It is possible to calculated a filed in the dashboard, instead of having the date range in the query:

Sum(Iif(DateDiffDay([Date], Today()) <= 15 And [Date] > Today(), [PlannedCapacity], 0))

 

Resources Interruptions Rate

DASHBO~1_img18

This gauge shows the percentage of interruption hours from the total capacity hours of all the resources.

This indicator includes by default the last 3 months as the data range, active resources only with capacity planning and it excludes the resources set for service or cost. Only interruptions with completed or active status are taken into consideration for this gauge.

 

Data Items used

Description

View/Table field

Interruption duration

Total interruption duration in hours. Only those hours are taken into account that interfered with the resource working schedule during the last 3 months.

View: BEASV_RESOURCE_UTILIZATION."InterruptionDuration"

Planned capacity

Planned capacity hours of the calculated resources in the last 3 months.

View: BEASV_RESOURCE_UTILIZATION."PlannedCapacity"


Help URL: https://help.beascloud.com/beas202402/index.html?resource_gauges.htm