How can I get GCP FlexReports to match with Cost History?

Products

• CloudHealth

Issue/Introduction

The key filters to include in FlexReports are "Project_id Not equal to null" and "Cost_Type Containing regular".

Example:

 

About Project_Id In , the cost associated with line items that have the project_id as null is already handled. To view the Total Reallocated Cost, use the gcp/project_id IS NOT NULL filter. The following are the filter recommendations for a query that compares GCP dataset with the GCP Cost History v2 at the billing account level:

In FlexReports, the cost associated with line items that have the project_id as null is already handled. However, these line items are not deleted from the dataset. To view the Total Reallocated Cost, use the gcp/project_id IS NOT NULL filter. With this, the additional line items in the FlexReports dataset will not be considered.

 

NOTE:  GCP corrects the cost of the line items which could cause Cost_Type to have a rounding error. To address the rounding error, the query includes the Cost_Type filter set to %regular%.