How to calculate calculated field and the non-calculated field in Quicksight
I’m hitting problem that can not calculate calculated field and non-calculated field.
I want to calculate cpa of advertisement.
So i made the below formula.
{advertisement_budget} / countIf({id[user]}, {utm_source} = “advertisement”)
But quicksight can not combine calculated field and non-calculated field.
How can i solve this problem?
Fixed Start Date with Dynamic End Date Filtering in Table Visual in QuickSight
The task is to create a calculated field in Quicksight where,