beastmode help. Nuanced conversion rate.
I have a conversion metric that I use a beastmode to calculate it it's pretty straight forward. Rentals/Inquiries as can be seen below in the calc.
sum(case when `unit_rented_c` = 'true' then 1 end)/count(`id`)
Now what I am trying to do is take these inquiries that haven't yet converted to a 'unit rented', but are in a status called 'Future Date Rentals' and add them in the beastmode above in the numerator. So that all those that converted to a rentals and in the FDR status are considered as 'converted' in the calculation.