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.
Answers
-
Are you looking for this to be your calculation?
sum(case when `unit_rented_c` = 'true' or status = 'Future Date Rentals' then 1 end)/count(`id`)
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass that 'or' is kind of throwing me off. basically all I want to do is take the count of FDR's and add them to the count of unit_rented_c then divide them by the 'id' for a new conversion %
FDR is a status inquiries go in that I want to count as already being converted to a rental, even though the status hasn't officially changed to a rental.
0 -
Based on the logic I added, this is how each would be evaluated:
Does this look correct to you? Or am I not understanding something?
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
aaahhh, no I made a gaffe with that data. You wouldn't see any FDR's with a 'true' . My bad, all FDR's will be 'False' because they have not converted to a rental yet, I want to treat them like they have and be added to the count of those that have been converted that are labeled 'true'.
0 -
I believe my logic would work for what you are wanting.
If it is a future dated rental, count it.
If unit_rented_c is true, count it.
Otherwise, don't count it.
You could also write it this way if you want.
sum(case when `unit_rented_c` = 'true' then 1 when status = 'Future Date Rentals' then 1 else 0 end)/count(`id`)
I added in the else statement because I find it clearer to have a result for all case scenarios.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
@MarkSnodgrass Last question and this should bring it full circle. How could I aggregate 2 values in the same column. Say in the
status
columns i wanted to add up all the 'Converted' and 'Future Dated Rental' values then divide them byid
?0 -
You could do this:
sum(case when status = 'Converted' then 1 when status = 'Future Date Rentals' then 1 else 0 end)/count(`id`)
This would add based on either one.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive