Beast Mode Help: Calculating Hit Rate (Projects & Quotes)
Here is a short video overview of what I am trying to accomplish: https://youtu.be/Dz_uXS1OGco
In simple terms the Project Hit Rate is the Count of (distinct) "Project Name" where "Convereted to Order?"='Yes' divided by the total Count of (distinct) "Project Name".
In simple terms the Quote Hit Rate is the Count of (distinct) "Quote Number" where "Convereted to Order?"='Yes' divided by the total Count of (distinct) "Quote Number".
A project might consist of multiple quotes, if any 1 of the quotes has "Convereted to Order?"='Yes' then the project is counted as a won project in the calculation above. Project Hit Rate = 100%
In the case of quotes, if say there are 4 quotes on the project and only one of them is "Convereted to Order?"='Yes' then the quote hit rate is 25%
My current Beast Modes:
Project Hit Rate:
CASE WHEN IFNULL(COUNT(DISTINCT `Project Name`),0)=0 THEN 0 ELSE CASE when `Converted to Order?`='Yes' then COUNT(`Project Name`) else 0 END / COUNT(DISTINCT `Project Name`) END 
Quote Hit Rate:
CASE WHEN IFNULL(COUNT(`Quote Number`),0)=0 THEN 0 ELSE CASE when `Converted to Order?`='Yes' then COUNT(`Quote Number`) else 0 END / COUNT(`Quote Number`) END 
I should note I am using subtotals in the table card, and the subtotals are not working. Thanks in advance for your help!
Comments

I figured it out on my own. Post solution in case others have the same issue.
I was over complicating the Beast Modes:
Project Hit Rate:
CASE
WHEN IFNULL(COUNT(`Quote Number`),0)=0
THEN 0
ELSE
Sum(case when `Converted to Order?`='Yes' then 1 else 0 end)
/
COUNT(DISTINCT `Project Name`)
ENDQuote Hit Rate:
CASE
WHEN IFNULL(COUNT(`Quote Number`),0)=0
THEN 0
ELSE
Sum(case when `Converted to Order?`='Yes' then 1 else 0 end)
/
COUNT(`Quote Number`)
END2
Categories
 10.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 297 仲間に相談
 649 ひらめき共有