Success rate calculation
I'm trying to work out the success rate of applications submitted, attached is a basic flow diagram of how this calculation works.
I have setup an ETL which filters out any withdrawn applications and separates the approved and refused applications.
Is there a way that I can sum the values of Approved Applications and Approved/Refused applications? I could then do a divide calculation to get the success rate.
Thankyou in advance!
Answers

You could utilize a formula tile or a beast mode (if you want to apply filtering dynamically to your calculation) to calculate it:
`Approved` / (`Approved` + `Refused`)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 
@louiswatson As you have it set up now, if you haven't already, you'll need to add a column to each branch named something like 'Type' that identifies 'Refused' for the Refused branch and 'Approved' for the Approved branch and then append the two. Then do the following:
SUM(case when 'Type' = 'Approved' then 1 else 0 end)/SUM(1)
Also, if you're able to, I would suggest creating the 'Type' tag in a formula tile and then you don't need to have the split and then append. It'll simplify things and do it in just one step instead of multiple.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0 
Thankyou both, @RobSomers I tried the formula but the value didn't come back as expected. I have used a Group By after adding the 'Type' column.
What would be the best way to work out Approved/Approved and Refused?
Many thanks
0 
@louiswatson You would use the formula I gave you as a beast mode in a card if the data was at an application grain. You can use a Rank & Window tile to get the totals after the Group By tile and join it to your groups and do the calculation from there, or you can use the FIXED function in a formula tile to do the calculation all in one go.
https://domohelp.domo.com/hc/enus/articles/4408174643607BeastModeFIXEDFunctions
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
0 
@RobSomers if I already have the totals using Group By, do I need to use rank & window too?
I had a go with the FIXED function but wasn't sure if this was being used in the right way?
Now I have the totals I just need to get my head around the calculation, it should work out to be 1017 (total applications) / Approved (612) = %
0 
Attached is the error that I had with the FIXED function, this calculation would have worked out the total applications submitted. I would need to filter out other, then work out 'approved' and 'approved and refused'.
0
Categories
 11.3K All Categories
 6 Private Company Board
 2 APAC User Group
 12 Welcome
 45 Domo News
 10.2K Using Domo
 2K Dataflows
 2.6K Card Building
 2.3K Ideas Exchange
 1.2K Connectors
 353 Workbench
 269 Domo Best Practices
 13 Domo Certification
 482 Domo Developer
 58 Domo Everywhere
 112 Apps
 734 New to Domo
 86 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 305 仲間に相談
 667 ひらめき共有