FOCUSExplorer
Queries
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Allocate multi-currency charges per application

Inspect the result, its parameters and the SQL behind it.

← All queries
Source
FOCUS use-case library
Data
FOCUS 1.0 sample
Status
Adapted to v1.0
Mode
Read-only
Library snapshot (UTC)
2026-10-08
Source
FOCUS 1.0 sample
Result rows
500
Status
Adapted to v1.0
Execution
PrecomputedRead-only
Result snapshot (UTC)
2026-10-11

Totals billed cost per application tag, provider, billing account and billing currency so multi-currency charges can be allocated per application. The sample has no ApplicationId tag; its application tag key is lowercase 'application', and rows without the tag are labelled '(untagged)'. About 8,000 application groups exist, so the 500 with the largest absolute billed cost are kept. All populated billing currencies in the sample are USD.

Column adaptations (1)
  • Tags["ApplicationId"] → tags->>'application': Same application identifier tag under the key this sample actually uses.

Billed cost by application and currency

Chart controls and notes

Showing the first 20 categories. Open full screen to explore all 499 categories.

Query results
Application idProvider nameBilling account idBilling account nameBilling currencyTotal billed cost
BrightPathMatrixAWS1234567890123SunBirdUSD$1,374.63
(untagged)AWS1234567890123SunBirdUSD-$1,047.31
(untagged)Microsoft/providers/Microsoft.Billing/billingAccounts/8611537SunBirdUSD$567.21
ZoomMapMaxAWS1234567890123SunBirdUSD$24.38
PureGeniusPilotAWS1234567890123SunBirdUSD$20.71
GlobalConsoleCloudAWS1234567890123SunBirdUSD$18.64
GenWebFlexAWS1234567890123SunBirdUSD$14.13
BrightInsightPortAWS1234567890123SunBirdUSD$14.11
GlobalClarityNextAWS1234567890123SunBirdUSD$9.43
MetaLabPowerOracle20209880–USD$7.87
ClearSolutionLogicAWS1234567890123SunBirdUSD$6.95
GreenGuideIQAWS1234567890123SunBirdUSD$6.21
PrimeNavigatorWaveAWS1234567890123SunBirdUSD$5.81
ProAccessPilotAWS1234567890123SunBirdUSD$4.79
OmniBoltFlexAWS1234567890123SunBirdUSD$4.77
FastSystemPathOracle20209880–USD-$4.74
ClearWebCentralAWS1234567890123SunBirdUSD$4.71
PowerRadarCoreAWS1234567890123SunBirdUSD$4.71
LeadChainLiteAWS1234567890123SunBirdUSD$4.66
ProEngineMatrixAWS1234567890123SunBirdUSD$3.70
ZoomBridgeInsightAWS1234567890123SunBirdUSD$3.44
ProMatrixCentralAWS1234567890123SunBirdUSD$3.23
BlueControlTechOracle20209880–USD-$3.20
VisionToolkitConnectOracle20209880–USD$3.20
EvolveManagerPortOracle20209880–USD$3.20
BlueScopeInsightAWS1234567890123SunBirdUSD$3.20
DynamicScopeEdgeOracle20209880–USD$3.20
SafeDNACentralAWS1234567890123SunBirdUSD$3.13
BlueLensIQOracle20209880–USD$3.07
HyperOptimizerStudioAWS1234567890123SunBirdUSD$2.91
GenBoxLiteAWS1234567890123SunBirdUSD$2.88
ActiveManagerLinkAWS1234567890123SunBirdUSD$2.85
MetaNavigatorEngineAWS1234567890123SunBirdUSD$2.84
SmartAccessSmartAWS1234567890123SunBirdUSD$2.81
OptiBoxProAWS1234567890123SunBirdUSD$2.80
OptiZoomInfinityAWS1234567890123SunBirdUSD$2.78
ProOptimizerForceAWS1234567890123SunBirdUSD$2.73
DynamicFocusHubAWS1234567890123SunBirdUSD$2.72
MaxPortalFusionAWS1234567890123SunBirdUSD$2.70
TrueStreamEssentialsAWS1234567890123SunBirdUSD$2.57
BlueManagerInfinityAWS1234567890123SunBirdUSD$2.54
AllProjectorSmartAWS1234567890123SunBirdUSD$2.48
ZoomLinkCloudAWS1234567890123SunBirdUSD$2.42
FlexGeniusFlowAWS1234567890123SunBirdUSD$2.42
EvolveVaultLabAWS1234567890123SunBirdUSD$2.30
PrimeMirrorFusionAWS1234567890123SunBirdUSD$2.22
EvolveLabEssentialsAWS1234567890123SunBirdUSD$2.18
CorePortalMaxAWS1234567890123SunBirdUSD$2.16
GenBoltEssentialsAWS1234567890123SunBirdUSD$2.06
PrimeRingHubAWS1234567890123SunBirdUSD$1.95
SecureBoltFusionAWS1234567890123SunBirdUSD$1.91
MaxCodeEssentialsAWS1234567890123SunBirdUSD$1.84
BluePrimeDriveAWS1234567890123SunBirdUSD$1.81
AlphaZoomPulseAWS1234567890123SunBirdUSD$1.79
BrightModelPowerAWS1234567890123SunBirdUSD$1.78
PowerPilotEssentialsAWS1234567890123SunBirdUSD$1.74
MetaEngineEssentialsOracle20209880–USD$1.60
OptiDriveCentralAWS1234567890123SunBirdUSD$1.58
PrimeCompassMatrixAWS1234567890123SunBirdUSD$1.57
GenFlowPrimeAWS1234567890123SunBirdUSD$1.55
EasyLogicConnectAWS1234567890123SunBirdUSD$1.55
PrimeLabEngineAWS1234567890123SunBirdUSD$1.54
ClearNetworkBoostAWS1234567890123SunBirdUSD$1.54
BrightMapPulseAWS1234567890123SunBirdUSD$1.54
EasyPanelEssentialsOracle20209880–USD-$1.54
MetaSuiteLiteAWS1234567890123SunBirdUSD$1.54
NextAccessFusionAWS1234567890123SunBirdUSD$1.54
NextFusionMaxAWS1234567890123SunBirdUSD$1.54
QuickMapPulseAWS1234567890123SunBirdUSD$1.54
SecureProjectorPowerOracle20209880–USD$1.54
TrueDriveSphereOracle20209880–USD$1.54
QuickNavigatorDriveAWS1234567890123SunBirdUSD$1.47
VitalMindPortAWS1234567890123SunBirdUSD$1.47
AllVisionHubAWS1234567890123SunBirdUSD$1.45
MaxMatrixFlexAWS1234567890123SunBirdUSD$1.43
ProManagerMaxAWS1234567890123SunBirdUSD$1.42
TotalMatrixBoostAWS1234567890123SunBirdUSD$1.37
FastCloudPathAWS1234567890123SunBirdUSD$1.34
EasyZoomFlowAWS1234567890123SunBirdUSD$1.33
SecurePanelBoostAWS1234567890123SunBirdUSD$1.33
GenManagerGoAWS1234567890123SunBirdUSD$1.33
UltraCenterCloudAWS1234567890123SunBirdUSD$1.32
TotalEngineMatrixAWS1234567890123SunBirdUSD$1.31
MetaAccessDriveAWS1234567890123SunBirdUSD$1.27
TotalMapBoostAWS1234567890123SunBirdUSD$1.24
BrightPortalVisionAWS1234567890123SunBirdUSD$1.15
AlphaCloudCloudAWS1234567890123SunBirdUSD$1.15
InsightNavigatorFusionAWS1234567890123SunBirdUSD$1.15
PowerBuilderCentralAWS1234567890123SunBirdUSD$1.15
BrightLensMatrixAWS1234567890123SunBirdUSD$1.13
ClearCodePulseAWS1234567890123SunBirdUSD$1.11
GenFactorZoneAWS1234567890123SunBirdUSD$1.11
MetaCompassMatrixAWS1234567890123SunBirdUSD$1.10
BrightDriveVisionAWS1234567890123SunBirdUSD$1.09
ActiveRingEngineAWS1234567890123SunBirdUSD$1.09
CoreBuilderNowAWS1234567890123SunBirdUSD$1.08
PrimeManagerDriveAWS1234567890123SunBirdUSD$1.07
PowerScopePilotAWS1234567890123SunBirdUSD$1.04
UnifiedStoreEngineAWS1234567890123SunBirdUSD$1.02
TechMatrixNextAWS1234567890123SunBirdUSD$1.02

Showing 100 of 500 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select coalesce(tags->>'application', '(untagged)') as application_id,
       provider_name as provider_name,
       billing_account_id as billing_account_id,
       billing_account_name as billing_account_name,
       billing_currency as billing_currency,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
group by 1, provider_name, billing_account_id, billing_account_name, billing_currency
order by abs(sum(billed_cost)) desc nulls last, application_id, provider_name
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

SELECT 
  Tags["ApplicationId"],
  ProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE
  BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  Tags["ApplicationId"],
  ProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency