2.9 Custom Columns
Since:
0.5
2.9.1 Description
FOCUS supports the inclusion of custom columns to facilitate reporting capability that is not covered by the columns included in the specification. See Dataset Completeness for requirements on when custom columns should be included.
2.9.2 Directly Dependent Columns
x_CustomColumn
2.9.3 Example SQL Query
Example SQL Query
SELECT
BillingPeriodStart,
x_CustomColumn,
SUM(BilledCost) AS TotalBilledCost,
FROM focus_data_table
WHERE ServiceName = ?
AND BillingPeriodStart >= ? AND BillingPeriodStart < ?
GROUP BY
BillingPeriodStart,
x_CustomColumn
ORDER BY MonthlyCost DESC