I have a calculated field ss-total cost that uses the following expression “{daily_cost} + {unblended_cost}”. My intent is to have a new column (ss-Total Cost) that shows
the sum of “daily cost” and “unblended_cost” for each day. As you can see from the screenshot, I believe I am getting some sort of aggregated cost.
Any suggestion on how to resolve this issue?
Hi @ssmayamp,
Are ‘daily_cost’ and ‘unblended_cost’ calculated fields? If so, could you share each of them?
Thank you
Hi @Brett …Field “Cost_Unblended” is a calculated field with the expression “Unblended_cost”
Field “Unblended_cost” is not a calculated field
Field “daily_cost” is not a calculated field
The dataset is a inner join between 2 tables
Join clause is usage_date
Hi @ssmayamp,
If you’re going to be joining tables, you’ll need to join them by a unique identifier (like a transaction ID, User ID, etc.), not a date. Doing that can cause values to aggregate improperly or multiply.
I imagine this may have something to do with why you’re getting incorrect values here.
1 Like
Hi @ssmayamp, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!