All Apps and Add-ons

There is no "COST" field in the aws-bill index

karthik40us
Explorer

There is no "COST" field in the aws-bill index. Can someone help ?. Is this a "Calculated Field" ?

The below search part of "AWS Resources Cost Dashboard" does not populate the Cost (timechart). The field Cost in the below search query is not part of the indexed fields.

index=aws-bill ProductName="Amazon Elastic Compute Cloud" | timechart sum(Cost) as $

Tags (1)
0 Karma

monkee
Path Finder

If you have a single AWS account and you don't use Consolidated billing your report only contains the Rate and Cost Fields.

eg NON-CONSOLIDATED: Your search should look like this:

index=aws-bill | timechart sum(Cost) as $ by ItemDescription

If you have have multiple AWS accounts and use Consolidated billing your report contains BlendedRate, BlendedCost, UnBlendedRate and UnBlendedCost fields BUT not the Cost and Rate fields.

eg CONSOLIDATED: Your search should look like this:

index=aws-bill | timechart sum(BlendedCost) as $ by ItemDescription

This means you need different searches and dashboards for the different billing reports eg a Consolidated OR a Single billing account report.

From Amazon's own documentation:

   Keep in mind that blended rates apply only to Consolidated Billing customers.

http://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/con-bill-blended-rates.html

0 Karma

monkee
Path Finder

The AWS billing provides dashboards and views for either report type. But essentially you must know the type of billing you have setup for your account to choose the right type.

0 Karma
Get Updates on the Splunk Community!

Learn Splunk Insider Insights, Do More With Gen AI, & Find 20+ New Use Cases You Can ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Buttercup Games: Further Dashboarding Techniques (Part 7)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Stay Connected: Your Guide to April Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...