Dataset Calculated Fields

Calculated Field	Cost Management	Marketplace Spending	Container Allocation	Savings Plans Management
Container Utilization Rate			X
Is Container Resource			X
Marketplace Total Cost		X
Marketplace Usage Cost		X
Marketplace Subscription Cost		X
Is Third Party		X
AWS Platform Cost		X
Spending Source	X	X
SP Coverage Rate				X
SP Savings Amount				X
Is SP Covered				X

Container Utilization Rate

ifelse(
  {split_cost} + {split_unused_cost} = 0, 
  NULL, 
  {split_cost} / ({split_cost} + {split_unused_cost})
)

Is Container Resource (Dimension)

ifelse(isNotNull({split_cost}) AND {split_cost} > 0, "Yes", "No")

Marketplace Total Cost

ifelse({billing_entity} = "AWS Marketplace", {unblended_cost}, 0)

Marketplace Usage Cost

ifelse({billing_entity} = "AWS Marketplace" AND {charge_type} = "Usage", {unblended_cost}, 0)

Marketplace Subscription Cost

ifelse({billing_entity} = "AWS Marketplace" AND {charge_type} = "Fee", {unblended_cost}, 0)

Is Third Party (Dimension)

ifelse({billing_entity} = "AWS Marketplace", "Yes", "No")

AWS Platform Cost

ifelse({billing_entity} = "AWS", {unblended_cost}, 0)

Spending Source (Dimension)

ifelse({billing_entity} = "AWS Marketplace", "Marketplace", "AWS")

SP Coverage Rate

ifelse(
  {charge_type} = 'SavingsPlanCoveredUsage',
  {savings_plan_coverage} / nullIf({savings_plan_coverage} + {savings_plan_effective_cost}, 0),
  NULL
)

SP Savings Amount

ifelse(
  {charge_type} = 'SavingsPlanCoveredUsage',
  {savings_plan_coverage} - {savings_plan_effective_cost},
  0
)

Is SP Covered

ifelse({savings_plan_coverage} > 0, "Yes", "No")

AI Cost

ifelse(strlen({ai_operation_type}) > 0, {cost}, NULL)

AI Region Type

ifelse(
  locate('_Global', {usage_type}) > 0 AND strlen({ai_operation_type}) > 0, 'Global (Cross-Region)',
  ifelse(strlen({ai_operation_type}) > 0, 'Regional (Hardcoded)', NULL)
)