Functions to help manipulate FinOps FOCUS data
- Extract structured tag values from JSON (
extractTags). - Transform FOCUS records by adding extracted tags and removing unwanted columns (
transformLine). - Aggregate FOCUS cost data by time intervals (
daily,monthly,yearly) and group by tags, SKUs, services, etc. (aggregateData). - Create sample FOCUS data with hourly granularity
- Type-safe, sandbox-friendly, and 100% test covered.
- Uses js-big-decimal so you no longer have to keep wondering why $0.10 + $0.20 equals bankruptcy 😅
npm install focus-ninjaBasic Examples
import { aggregateData } from 'focus-ninja';
const aggregated = aggregateData({
data: focusDataset, // Your parsed FOCUS dataset
interval: 'yearly',
groupBy: ['ServiceCategory', 'CostCenter'], // you can also group by tags directly, in this case: CostCenter
r
896C
ound: 10, // (optional) round up the aggregated data to 10 decimal places
});
// Returns yearly aggregated cost data, grouped by ServiceCategory and CostCenterimport { extractTags } from 'focus-ninja';
const tagString = '{"project": "FinOps", "environment": "prod"}';
const keys = ['project', 'environment', 'costCenter'];
const fallbacks = { costCenter: 'defaultCostCenter' };
const result = extractTags(tagString, keys, fallbacks);
console.log(result);
// Output: { project: "FinOps", environment: "prod", costCenter: "defaultCostCenter" }// Note the separate import to avoid bloating the import size of the other functions
import { createSampleData } from 'focus-ninja/sampleData';
const year = 2022;
const month = 5;
const day = 3;
const sampleData = createSampleData(year, month, day, 10000);import { extractTags, transformLine, FocusLine } from 'focus-ninja';
const sampleLine = (sampleLine = {
AvailabilityZone: null,
BilledCost: 0.027,
BillingAccountId: '1234567890123',
BillingAccountName: 'SunBird',
BillingCurrency: 'USD',
BillingPeriodEnd: '2024-10-01 00:00:00',
BillingPeriodStart: '2024-09-01 00:00:00',
ChargeCategory: 'Usage',
ChargeClass: null,
ChargeDescription: '$0.027 per Application LoadBalancer-hour',
ChargeFrequency: 'Usage-Based',
ChargePeriodEnd: '2024-09-17 16:00:00',
ChargePeriodStart: '2024-09-17 15:00:00',
CommitmentDiscountCategory: null,
CommitmentDiscountId: null,
CommitmentDiscountName: null,
CommitmentDiscountStatus: null,
CommitmentDiscountType: null,
ConsumedQuantity: 1,
ConsumedUnit: 'Hours',
ContractedCost: 0,
ContractedUnitPrice: 0,
EffectiveCost: 0,
InvoiceIssuerName: 'Amazon Web Services, Inc.',
ListCost: 0.027,
ListUnitPrice: '0.027',
PricingCategory: 'Standard',
PricingQuantity: 1,
PricingUnit: 'Hours',
ProviderName: 'AWS',
PublisherName: 'Amazon Web Services, Inc.',
RegionId: 'eu-central-1',
RegionName: 'EU (Frankfurt)',
ResourceId: 'arn:aws:elasticloadbalancing:eu-central-1:561134494941:app/pieto-api/7b29febfbe87',
ResourceName: null,
ResourceType: null,
ServiceCategory: 'Networking',
Id: 128,
ServiceName: 'Elastic Load Balancing',
SkuId: 'UZQQFKE5Z4MCF9D5',
SkuPriceId: 'UZQQFKE5Z4MCF9D5.JRTCKXETXF.6YS6EN2CT7',
SubAccountId: '84445137922',
SubAccountName: 'Pioneer Nimbus',
Tags: '{"application": "DynamicGuideZone", "environment": "prod", "business_unit": "KnoxvilleEngineering"}',
});
const transformedLine = transformLine({
line: sampleLine,
tagKeys: ['application', 'environment'],
fallbackValues: { application: 'fallbackApp' },
columnsToRemove: ['RegionName', 'SkuId'],
});
// returns the sample line with new properties for application and environment, and removes the properties Tags, RegionName, SkuIdWant to improve focus-ninja? Check out our contribution guide! 🚀