Can business metrics implement filters on the values? What I'm trying to do is get a column for 'Total Cost without Credits.'
So I might have three columns, 1 dimension (month) and 2 metrics: Total Cost & Usage Cost. This saves me from having to generate and merge two different reports.
I thought something like this would work
```
"name": "Total Usage Cost",
"index": 3,
"kind": "BUSINESS_METRIC",
"preMatchExpression": "(DIMENSION['vendor'] == 'amazon' || DIMENSION['vendor'] == 'azure' || DIMENSION['vendor'] == 'gcp')",
"defaultValue": "METRIC['unblended_cost']",
"numberFormat": "currency",
"updatedAt": "2023-11-10T22:26:12.669Z",
"statements": [
{
"matchExpression": "DIMENSION['transaction_type'] == 'usage'",
"valueExpression": "METRIC['unblended_cost']"
}
]
}
```
but it just returns the unblended cost, not a filtered number applied to the unblended cost. I am trying to see if the valueExpression can output the usage number, not the the total unblended cost.
#Cloudability