Power Platform Community Forum Thread Details

hi,

I have a JSON file of the following format. I want to Sum the total_cost per service_name and usage_date.

Thanks for the help

[

{

"group_by": "Amazon Elastic Compute Cloud",

"usage_date": "2024-03-01",

"account_id": "857346950259",

"service_name": "Amazon Elastic Compute Cloud",

"total_cost": 1037.49916,

"total_usage_quantity": 4654.7396076438,

"resource_name": "",

"resource_id": ""

{

"group_by": "Amazon Elastic Container Service for Kubernetes",

"usage_date": "2024-03-01",

"account_id": "857346950259",

"service_name": "Amazon Elastic Container Service for Kubernetes",

"total_cost": 426.107122,

"total_usage_quantity": 21358.95326387,

"resource_name": "",

"resource_id": ""

Categories:

Sum cost data from JSON by two variables Service and Date