Please check if you are using the correct field line_item_unblended_cost , not to be confused with pricing_public_on_demand_cost.
Please refer to one of our self-paced labs which can be used as reference on creating views which is similar to what you are trying to achieve.
AWS Cost Explorer Tags Not Showing All CloudFormation Stacksasked 6 months ago
How to disable Cost Explorer?asked 7 months ago
Identifying amortized cost column in AWS cost and usage reportasked 9 months ago
Disable AWS Cost Explorer permissionsasked 8 months ago
Cost explorer boto3 cost and usage without specific tagasked 9 months ago
In Cost Explorer, what CloudFront charge showsAccepted Answerasked 2 years ago
Cost Explorer widget doesn't show all tagsasked a month ago
AWS Cost Explorer Unblended cost does not match CUR report unblended costasked 5 months ago
Account name changes are not reflected in Cost Explorerasked 6 months ago
Fargate cost allocation tags not showing up in cost explorerAccepted Answerasked 3 months ago