I need to perform a nested calculation as shown below:
Here I need to create a calculated field "Acceptance Rate" for each ID. The formula will look like: Acceptance Rate= Accept / (Accept + Hard Reject + Pending)
Is it possible to do it quickly in Tableau, I know this can be done in few seconds in excel. Is there some quick & easy way to perform such calculations in Tableau??
Try SUM(IF [Ultimate Decision] = 'Accept' THEN 1 END)/COUNT([EJP User Id])