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 to any 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 to any 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 to any 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 to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive