Main Dashboard: Green Dashboard

This Green Dashboard tab displays the KPIs related to Green initiative. The actual value of the KPI is compared against the target value with a two-color gauge showing the status of the comparison.

The reports for this tab are located in the catalog in:

/Shared Folders/FTI Reports/_portal/Main Dashboard/Green Dashboard – Fuel Consumption
/Shared Folders/FTI Reports/_portal/Main Dashboard/Green Dashboard – Emission Foot Print

Emission Foot Print

Metric	Definition	Formula	Threshold (Stop Light) Definition
CO2 Emission	Indicates the total carbon dioxide (CO2) emissions from shipments (truckload only).	case when ("- Shipment Targets"."CO2 Emission Target" is NULL or "- Shipment Targets"."CO2 Emission Target" = 0) and ("- Shipment Facts"."CO2 Emission" is NULL or "- Shipment Facts"."CO2 Emission" = 0) then 100 else ("- Shipment Targets"."CO2 Emission Target") end	CO2 emission is greater than 100% of target value then green. CO2 emission is less than 100% of target value then red. If no data exists for the selected criteria then gray.
NOx Emission	Indicates the total nitrous oxide (NOx) emissions from shipments (truckload only).	case when ("- Shipment Targets"."NOx Emission Target" is NULL or "- Shipment Targets"."NOx Emission Target" = 0) and ("- Shipment Facts"."NOx Emission" is NULL or "- Shipment Facts"."NOx Emission" = 0) then 100 else ("- Shipment Targets"."NOx Emission Target") end	NOx emission is greater than 100% of target value then green. NOx emission is less than 100% of target value then red. If no data exists for the selected criteria then gray.
PM Emission	Indicates the total particulate matter (PM) emissions from shipments (truckload only).	case when ("- Shipment Targets"."PM Emission Target" is NULL or "- Shipment Targets"."PM Emission Target" = 0) and ("- Shipment Facts"."PM Emission" is NULL or "- Shipment Facts"."PM Emission" = 0) then 100 else ("- Shipment Targets"."PM Emission Target") end	PM emission is greater than 100% of target value then green. PM emission is less than 100% of target value then red. If no data exists for the selected criteria then gray.

Metric

Definition

Formula

Threshold (Stop Light) Definition

CO2 Emission

Indicates the total carbon dioxide (CO2) emissions from shipments (truckload only).

case when ("- Shipment Targets"."CO2 Emission Target" is NULL or "- Shipment Targets"."CO2 Emission Target" = 0) and ("- Shipment Facts"."CO2 Emission" is NULL or "- Shipment Facts"."CO2 Emission" = 0) then 100 else ("- Shipment Targets"."CO2 Emission Target") end

CO2 emission is greater than 100% of target value then green.

CO2 emission is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

NOx Emission

Indicates the total nitrous oxide (NOx) emissions from shipments (truckload only).

case when ("- Shipment Targets"."NOx Emission Target" is NULL or "- Shipment Targets"."NOx Emission Target" = 0) and ("- Shipment Facts"."NOx Emission" is NULL or "- Shipment Facts"."NOx Emission" = 0) then 100 else ("- Shipment Targets"."NOx Emission Target") end

NOx emission is greater than 100% of target value then green.

NOx emission is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

PM Emission

Indicates the total particulate matter (PM) emissions from shipments (truckload only).

case when ("- Shipment Targets"."PM Emission Target" is NULL or "- Shipment Targets"."PM Emission Target" = 0) and ("- Shipment Facts"."PM Emission" is NULL or "- Shipment Facts"."PM Emission" = 0) then 100 else ("- Shipment Targets"."PM Emission Target") end

PM emission is greater than 100% of target value then green.

PM emission is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Fuel Consumption

Metric	Definition	Formula	Threshold (Stop Light) Definition
Total Distance	Total distance of shipments	case when ("- Shipment Targets"."Total Distance Target" is NULL or "- Shipment Targets"."Total Distance Target" = 0) and ("- Shipment Facts"."Planned Distance Base" is NULL or "- Shipment Facts"."Planned Distance Base" = 0) then 100 else ("- Shipment Targets"."Total Distance Target") end	Total distance is greater than 100% of target value then green. Total distance is less than 100% of target value then red. If no data exists for the selected criteria then gray.
Total Shipments	Total number of shipments	case when ("- Shipment Targets"."Total Shipments Target" is NULL or "- Shipment Targets"."Total Shipments Target" = 0) and ("- Shipment Facts"."Shipment Count" is NULL or "- Shipment Facts"."Shipment Count" = 0) then 100 else ("- Shipment Targets"."Total Shipments Target") end	Total shipments are greater than 100% of target value then green. Total shipments are less than 100% of target value then red. If no data exists for the selected criteria then gray.
Total Fuel Consumption	Total fuel consumption	case when ("- Shipment Targets"."Total Fuel Consumption Target" is NULL or "- Shipment Targets"."Total Fuel Consumption Target" = 0) and ("- Shipment Facts"."Total Fuel Consumption" is NULL or "- Shipment Facts"."Total Fuel Consumption" = 0) then 100 else ("- Shipment Targets"."Total Fuel Consumption Target") end	Total fuel consumption is greater than 100% of target value then green. Total fuel consumption is less than 100% of target value then red. If no data exists for the selected criteria then gray.

Metric

Definition

Formula

Threshold (Stop Light) Definition

Total Distance

Total distance of shipments

case when ("- Shipment Targets"."Total Distance Target" is NULL or "- Shipment Targets"."Total Distance Target" = 0) and ("- Shipment Facts"."Planned Distance Base" is NULL or "- Shipment Facts"."Planned Distance Base" = 0) then 100 else ("- Shipment Targets"."Total Distance Target") end

Total distance is greater than 100% of target value then green.

Total distance is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Total Shipments

Total number of shipments

case when ("- Shipment Targets"."Total Shipments Target" is NULL or "- Shipment Targets"."Total Shipments Target" = 0) and ("- Shipment Facts"."Shipment Count" is NULL or "- Shipment Facts"."Shipment Count" = 0) then 100 else ("- Shipment Targets"."Total Shipments Target") end

Total shipments are greater than 100% of target value then green.

Total shipments are less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Total Fuel Consumption

Total fuel consumption

case when ("- Shipment Targets"."Total Fuel Consumption Target" is NULL or "- Shipment Targets"."Total Fuel Consumption Target" = 0) and ("- Shipment Facts"."Total Fuel Consumption" is NULL or "- Shipment Facts"."Total Fuel Consumption" = 0) then 100 else ("- Shipment Targets"."Total Fuel Consumption Target") end

Total fuel consumption is greater than 100% of target value then green.

Total fuel consumption is less than 100% of target value then red.

If no data exists for the selected criteria then gray.

Main Dashboard: Green Dashboard

Emission Foot Print

Fuel Consumption

Related Topics