As a Finance person, I want to understand the recurring costs of commitment based discounts over a period of time to improve forecasting.
Column names from the source use case.
2 rows. Scroll inside the table to see more.
select billing_period_start,
commitment_discount_id,
coalesce(commitment_discount_name, regexp_replace(commitment_discount_id, '^.*/', '')) as commitment_label,
commitment_discount_name,
commitment_discount_type,
charge_frequency,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_start < $2::timestamptz
and charge_frequency = 'Recurring'
and commitment_discount_id is not null
group by 1, 2, 3, 4, 5, 6
order by billing_period_start, total_billed_cost desc nulls last, commitment_discount_id
limit 500SELECT BillingPeriodStart, CommitmentDiscountId, CommitmentDiscountName, CommitmentDiscountType, ChargeFrequency, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodStart < ? AND ChargeFrequency = 'Recurring' AND CommitmentDiscountId IS NOT NULL GROUP BY BillingPeriodStart, CommitmentDiscountId, CommitmentDiscountName, CommitmentDiscountType, ChargeFrequency