How can I check private pricing/General Credits within AWS reports?

Products

• CloudHealth

Issue/Introduction

There are a couple of ways we can view these credits:

 

1. Under Cost History report by selecting "COST WITHOUT DISCOUNTS" in Y-axis and selecting Category as "Detailed Charge Type":

 
2. Using a FlexReport. Similar to the example below flex report SQL can be used to capture the private pricing/Credits:
 

{
  "sqlStatement": "SELECT timeInterval_Month AS Month, SUM(lineItem_UnblendedCost) AS SUM_lineItem_UnblendedCost, bill_PayerAccountId AS Bill_PayerAccountId, bill_InvoiceId AS Bill_InvoiceId, lineItem_LineItemType AS LineItem_LineItemType FROM AWS_CUR WHERE ((lineItem_LineItemType LIKE '%Credit%') OR (lineItem_LineItemType LIKE '%EdpDiscount%')) GROUP BY timeInterval_Month, bill_PayerAccountId, bill_InvoiceId, lineItem_LineItemType",
  "needBackLinkingForTags": true,
  "dataGranularity": "MONTHLY",
  "timeRange": {
    "from": "2023-03",
    "to": "2023-03"
  },
  "limit": -1
}